Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm Option Button
I am new to UserForms (Excel 2003). I created a UserForm with 3 options that
input data into Cell A3 in a worksheet. However, you can exit the Userform by clicking 'OK' without selecting any of the options. I need at least one Option to be selected. I thought the following Code would help, but doesn't. I am hoping someone can help. Private Sub OK_Click() If Range("A3") = " " Then MsgBox "You Must Select the Source from this menu" UserForm1.SetFocus Exit Sub End If Unload Me End Sub Thanks Linda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retain value of userform option button | Excel Programming | |||
Populate userform combobox with option button | Excel Programming | |||
option button and userform question | Excel Programming | |||
need help on how to grey out one option button in one group box based on the selection of another option button in another group box | Excel Programming | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) |