Macro question

[joe busch]

Using Excel 2000:

I am creating an Excel document that lists a number of items that could be
included in an analysis. I have placed checkboxes next to each items and
have assigned macros to the checkboxes so that when checked, the selected
items are highlighted later on in the workbook. The problem is, when the
boxes go from checked to unchecked, the items don't become unhighlighted.
That is, although checking the box prompts the macro to run, unchecking the
box doesn't cause the macro to "un-run" or return things to their
pre-checked state. Any suggestions?

Thanks in advance for any and all kind suggestions

Joe

 

[Squid]

Did you add code for when the checkbox is value is
No/False/Off?

 

[joe busch]

No, but I have to admit that I am not sure how to do that. Will the
unchecking of the box allow the "no" option to then run?

Finally...any good sources on writing Excel macros?

Thanks in advance,
Joe