VBA: If Statement with Option Buttons

[JMK326]

In the code for a command button, I want to show different message boxes based on the option button that is selected. I can not get this code to work. Option button 1 & 2 are a group and Option Button 3 & 4 are a different group.

With the code below no matter what is selected, I get MESSAGE 3.

If OptionButton1.Select Then
If OptionButton3.Select Then
MsgBox ("MESSAGE 1")
Else
MsgBox ("MESSAGE 2")
End If
Else
MsgBox ("MESSAGE 3")
End If

 

[JMK326]

Figured it out.

If OptionButton1.Value = True worked!

 

[mikerickson]

Where are the option buttons, on a worksheet or a userform. If on a worksheet, are the Forms controls or ActiveX?

 

[mikerickson]

Figured it out.

If OptionButton1.Value = True worked!

The = True is not needed.

If OptionButton1.Value Then

 

[JMK326]

Thank you!