Results 1 to 12 of 12

Check boxes macro

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    Taunton, England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Check boxes macro

    Hi all,

    I have a problem trying to get a macro to work which is attached to a check box.

    the background is that it is for a monthly bonus sheet. Once the site reaches a certain level of recycling then the staff may be entitled to a bonus. The manager will enter the recycling rate in a specific cell at the bottom of the spreadsheet and their is a table on a separate tab which lists the different percentages and how much bonus they get.
    What I have is a tick box next to each individual (there may be reasons why certain staff dont get the bonus that month) and when the tickbox is ticked I want it to look up a percentage figure from cell B22 to work out how much bonus should be paid.

    I have managed to get this to work but what I also would like that when the checkbox is unticked then the bonus figure is deleted.

    Like I said, I have managed to get it to work for once the checkbox is ticked but cant get it to do the deleting bit!
    Last edited by Colhawk; 10-17-2012 at 04:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1