Caption of Command Buttons in Option Group 1

[cP6uH]

Hi,

Is there a way to get a caption of pressed command button in an option group.
So what I have is Option Group with let's say 4 options, and they're all command buttons. So, when user selects one, and clicks some other button to run some code, I'd like to get the caption of the option selected.

Is there a way to do that ??

Thank you,
Dragan

 

[Rolliee]

msgbox me.control(?).caption

will show the caption of the ? th control

rollie@bwsys.net

 

[cP6uH]

How do I find out what is the number of the selected control ?

 

[Rolliee]

do a

do an onclick event on the control and
enter

msgbox me.name

I am not sure about this but believe it will work. Send me your email address and I will send you an example


rollie@bwsys.net

 

[cP6uH]

Thanks a lot Rolliee, with your help I produced a code that works.

Here's the code if anyone ever needs to do something like this.

Dim i As Integer

For i = 0 To Me.Controls.Count - 1
If Me.Controls(i).Name = "Frame Name" Then Exit For
Next

MsgBox Me.Controls(Me.[Frame Name] + i + 1).Caption



Dragan