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!

Hi Colhawk

Please attach a file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not).

Hi Colhawk

Try this...let me know of issues

Please Login or Register  to view this content.

Hi jaslake,

Thanks for that solution. It works well for the first 3 people on the timesheet but upon the fourth person when I click the check box it comes up with an error saying "Runtime error 1004. The item with the specified name wasn't found"

I have checked that the checkbox is definitely named Check Box 22 (even cut and paste this in to make sure it was right) but still cannot seem to see why it isnt working, the line it has problems with is coloured in red below.

Please Login or Register  to view this content.

Thanks for any help you can give!

Hi Colhawk

First, please wrap your code in code tags.

Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

As to your issue...I don't know...there's something that's different. If you'll post the offending file one of us will look at it.

BUT FIRST, please wrap your code in code tags (Rule #3 explains how to do so).

Hi Colhawk

You don't have a Check Box 22. Right Click on your Check Boxes and Check the Names in the left most Formula Bar Window. The 4th Check Box down is named Check Box 23. Check all the others and revise your code accordingly...it'll work.

Sometimes I can't see the Forest for the Trees...

You're welcome...glad I could help. Thanks for the Rep.