OptionButton must be tru before running command button code

[ipbr21054]

On my userform i have 2 optionbuttons
Lets call them 1 & 2

Only 1 will ever be selected BUT before the command button code runs it must check if one of them is selected,if not should show msgbox advising user to make a selection

 

[Skyybot]

If CommandButton1 = False And CommandButton2 = False Then
MsgBox "Please select an option", vbCritical, "Selection"
 Exit Sub
End If

 

[ipbr21054]

Hi
How does that check if either of the OptionButtons are true ?

 

[Skyybot]

Hi
How does that check if either of the OptionButtons are true ?

It doesn't. Checked = True, Unchecked = False. In your OP you said you wanted to check if one of them has been checked. If both are Unchecked then a message pops up requesting the user to make a choice. Did I mis-understand your OP?

 

[ipbr21054]

Ah ok i read it wrong thanks