The use of options button (I'm sure theres a quick solution)

clares · Mar 22nd, 2002, 09:42 AM

I'm sure there is an easy way but have spent a while trying to it work out. I have put two option buttons on a dialog sheet (dialog1) and I am trying to write an if statement but can not seem to determine which button has been pressed. Can anyone help!!

Thank you in advance

Al Chara · Mar 22nd, 2002, 09:55 AM

To tell if an optionbutton has been pressed use the following:

if optionbutton1.value=true then
msgbox "Option Button 1 has been pressed"
elseif optionbutton2.value=true then
msgbox "Option Button 2 has been pressed"
end if

clares · Mar 22nd, 2002, 10:02 AM

Do I have to substite "optionbutton1" with the name that I have given it?

On 2002-03-22 08:55, Al Chara wrote:
To tell if an optionbutton has been pressed use the following:

if optionbutton1.value=true then
msgbox "Option Button 1 has been pressed"
elseif optionbutton2.value=true then
msgbox "Option Button 2 has been pressed"
end if

[/quote]

Tom Schreiner · Mar 22nd, 2002, 10:05 AM

AlChara has your solution. Make sure this code is placed in the option button's change or click event. Other events could be used as well...

Have Fun!

Tom Schreiner · Mar 22nd, 2002, 10:06 AM

Yes, I think you do

Mar 22nd, 2002, 09:55 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	To tell if an optionbutton has been pressed use the following: if optionbutton1.value=true then msgbox "Option Button 1 has been pressed" elseif optionbutton2.value=true then msgbox "Option Button 2 has been pressed" end if __________________ Kind regards, Al Chara

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

Mar 22nd, 2002, 09:42 AM	#1
clares Board Regular Join Date: Mar 2002 Location: Portsmouth.UK Posts: 543	I'm sure there is an easy way but have spent a while trying to it work out. I have put two option buttons on a dialog sheet (dialog1) and I am trying to write an if statement but can not seem to determine which button has been pressed. Can anyone help!! Thank you in advance

Mar 22nd, 2002, 10:02 AM	#3
clares Board Regular Join Date: Mar 2002 Location: Portsmouth.UK Posts: 543	Do I have to substite "optionbutton1" with the name that I have given it? On 2002-03-22 08:55, Al Chara wrote: To tell if an optionbutton has been pressed use the following: if optionbutton1.value=true then msgbox "Option Button 1 has been pressed" elseif optionbutton2.value=true then msgbox "Option Button 2 has been pressed" end if [/quote]

Mar 22nd, 2002, 10:05 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	AlChara has your solution. Make sure this code is placed in the option button's change or click event. Other events could be used as well... Have Fun!

Mar 22nd, 2002, 10:06 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Yes, I think you do