Check Box for Yes/No

[bjohnsonac]

I need to create a checkbox(s) for the user to click Yes OR No, Not both....I will be assigning a formatting macro based on which is selected - but I can't figure out how to limit them to either Yes or No -

Ideally, I would like it so if they click Yes, one macro runs, if they click No, the Yes would automatically unselect and another macro would run

Any help would be appreciated!

[shg]

Checkboxes are drawing objects, on a different layer than the cells. Unless you are comfortable with using them and familiiar with their quirks, I'd suggest you not use them, and use Marlett checkboxes instead. You'll find many examples in the forum and on the web.

[Marcol]

Or maybe use Optionbuttons?

See this rather primitive attachment