Hi everyone, I was given the following code to test a check box created from the "Forms" tools in a worksheet:
If ActiveSheet.Shapes("BUTTON_NAME").ControlFormat.Value = Checked Then MSG ("BLEH")
it works fine, but my question is, can i do the same thing with an option box? I'm trying to spit a message out when one of 3 option buttons is checked.
I tried naming one of the option buttons "BUTTON_NAME", but it doesnt trigger like a check box does.
thanks
If ActiveSheet.Shapes("BUTTON_NAME").ControlFormat.Value = Checked Then MSG ("BLEH")
it works fine, but my question is, can i do the same thing with an option box? I'm trying to spit a message out when one of 3 option buttons is checked.
I tried naming one of the option buttons "BUTTON_NAME", but it doesnt trigger like a check box does.
thanks