Polling Option Buttons (97, 2000)

[pshaas]

What is the proper way to poll a group of option buttons on a custom userform, given that they are identified by a common GroupName ??

I want to put this into the form's OK-button click event.

Tks,
~~~Paul

[LegareColeman]

Can you define what you mean by "poll a group of option buttons ?"

[pshaas]

Maybe 'polling' them isn't the right word...
Basically, what's the best way to tell which option button was selected out of the group?

~~~Paul

[sdckapr]

You can loop through them and see which one has a true value.

You might add a code to the click event of each one to do something or set something when an option is clicked.

Or you have code to do something based on which one is pressed:

if optionbutton1.value then
'do something
elseif optionbutton2.value then
'do something else
'add others as needed
endif

Steve