Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
verify state of option button
I have a group of four option buttons on a userform. The user is
required to check select one of them. What can I put in my code to verify this. What I currently have is below but it does not seem like it is the most efficient way of completing this task as I have this occurrence 34 separate times. sub verify() If opt1.Value = False And opt2.Value = False And opt3.Value = False And opt4.Value = False Then GoTo 2: ElseIf opt5.Value = False And opt6.Value = False And opt7.Value = False And opt8.Value = False Then GoTo 2 end if 'other code below .... exit sub 2: msgbox "Please verify that you have completed each section" end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
Triple state command button | Excel Programming | |||
Mouse-Over State on Graphic Button | Excel Programming | |||
triple state option buttons | Excel Programming | |||
state of option button | Excel Programming |