J
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
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