Evaluate OptionGroup in XL Dialog

[hglamy]

Hello there,

how do I know which option button has
been clicked on in a group / frame on a vba dialog.

Couldn't find an index property in vba dialogs as is
the case in vb.

Any help appreciated.

Kind regards,

H.G. Lamy

 

[Chip Pearson]

Try something like

Select Case True
Case Me.OptionButton1.Value
MsgBox "button1"
Case Me.OptionButton2.Value
MsgBox "button2"
Case Me.OptionButton3
MsgBox "button3"
End Select



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[hglamy]

Thank you Chip, that does it.

However, I don't understand why in the
XL-help file a frame control / grouping
is said to make the option buttons
automatically mutually exclusive.
That doesn't seem to work.

Anyway, I do it as you suggest, thanks,

Regards,

H.G. Lamy

 

[Chip Pearson]

You can in fact use the Frame control to group option buttons, and
you can also use the GroupName property to group several option
buttons on a form, without using a Frame control. What do you
mean specifically when you say that it doesn't seem to work?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[hglamy]

Chip,

while trying something like this:

For Each x In Frame1.Controls
....

I accidentally named "Frame1"
differently in code and properties.

My mistake.

Thank you for your help.

Regards,

H.G. Lamy