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

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



"hglamy" wrote in message
...
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

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" schrieb im Newsbeitrag
...
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



"hglamy" wrote in message
...
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

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



"hglamy" wrote in message
...
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" schrieb im Newsbeitrag
...
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



"hglamy" wrote in message
...
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,

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




"Chip Pearson" schrieb im Newsbeitrag
...
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



"hglamy" wrote in message
...
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" schrieb im Newsbeitrag
...
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



"hglamy" wrote in message
...
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