Option Groups in User Forms in Excel 1

[snowmantle]

Hi,

My question is how do I get the value of the selected radio button in an option group of radio buttons in an Excel User form?

 

[PHV]

Check the Value of the Frame ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[snowmantle]

Sorry adding to this in case it is unclear... I mean getting the value for use for passing into a function maybe as the correct name of the button so I know which one was selected.

 

[PHV]

Again, the value of the OptionGroup itself.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[snowmantle]

Sorry I cant find an OptionGroup, my toolbox doesnt have it in the list.

I first created 3 OptionButtons and set their GroupName property to be the same.

Where should I be looking? tried using a frame but that doesnt have a value to check.

 

[PHV]

Sorry, I thought I was in an access forum.
For MSForms, search which OptionButton is True:

If OptionButton1.Value = True Then
  'your stuff here
ElseIf OptionButton2.Value = True Then
...
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[snowmantle]

Thanks for your help. Shame about that one. All sorted now.