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

[clares]

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]

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]

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]

 

[Legacy 98055]

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!

 

[Legacy 98055]

Yes, I think you do