How to Use Option Button (Radio Button)

At VBA Editor, create a UserForm, select tool box,

Place 2 Option buttons and Name as:

OptChoice1 and its Caption as Choice One
OptChoice2 and its Caption as Choice Two
To know if user select Choice One, use the following code:

OptChoice1.Value =True
To check if optChoice2 is selected, try the following:

If optChoice2 .Value Then
Msgbox “User have selected Choice 2″
Else
Msgbox “User selected other choice”
End If