Easy option button question

I am new to option buttons and I have a pretty simple question. I have written a macro to run a certain way if the option button is clicked. So the code runs when

OptionButton1.Value = True

My easy question is: How do I set it back to being unclicked? Is there a line of code I should put in?

Please Login or Register  to view this content.

That's what I did, but it didn't work. I made a button you could push and I used

OptionButton1.Value = False

as the code, but I got an error. It says "Object Required". Any idea what's going on?

Sorry. I missed the post. If you wanted to keep the code in a module rather than in the sheet code, you just have to add the sheet name:

Please Login or Register  to view this content.

That's simple enough. Thanks for your help.