Check AND uncheck an option button

Originally Posted by pingwin77

I'm working on a book and I need to have an option button. How do you set up the button so that if you click it once, it selects then when you click it again it un-selects? Right now I can only click on it to select it then I can not un-select it again. Am I missing something?

One other quick question. What is the best way to have a formula respond to this option button? I know it works as a "true/false" but how do you have another cell reference the option button?

Thanks!

Hi,
A check box would be better for that situation, an option button works best when you have more than one option