Macro for selected/unselected checkbox?

**Orlic** · 01-25-2008, 01:13 PM

I've never used checkboxes before and I'm trying to get one to perform a macro when selected/unselected. When the box is selected I would like it to show certain rows, when it is unselected I would like it to hide those rows.

I'm currently using a combo box to do this, but plan to make the function available in a checkbox. Here's a sample of the combo box code I'm using:

Please Login or Register  to view this content.

It basically says if "0" is selected in the combo box, then range A_Set1 & A_Set2 will be hidden, otherwise if something besides "0" is selected then the two ranges are shown. I want this same concept (via checked vs/ unchecked) implemented into a checkbox.

Thanks for any help!

**Leith Ross** · 01-25-2008, 01:38 PM

Hello Orlic,

Please re-read the forum rules about posting. You obviously know about HTML tags, please use them to wrap your code in the future. You can read the rules by clicking Here.

As a member of the Forum, if you don't follow the rules there will be consequences. Your post may be locked or even deleted.

Thanks,
Leith Ross