Option button test question

robfo0 · Apr 23rd, 2002, 05:46 PM

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

robfo0 · Apr 23rd, 2002, 05:49 PM

Nevermind, it does work, i made a mistake, heh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 05:46 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	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

Apr 23rd, 2002, 05:49 PM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Nevermind, it does work, i made a mistake, heh