Option Button

[Colleen45]

Can I use a option button, with a IF statement, and how would I refer to the button in an if statement, if the condition is true. I don't wish to put the button on a form, I would like to have it on the worksheet. if I need to use VBA, what would the code be? Actually I would like to use 2 control buttons, and based on the buttons condition use IF statements.

 

[ArthriticPanda]

Hi Colleen,

Maybe this link will assist; no vba is required using this option:

Option Buttons

AP