Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Better / faster solution for OptionButtons?
I have a userForm with 5 OptionButtons within a Frame on it (there' also a ComboBox on this userForm, which is irrelevant to this issue.) In order to figure out which OptionButton was picked, I have thi snippet of code Code ------------------- If targetForm1 = True Then targetForm = 1 ElseIf targetForm2 = True Then targetForm = 2 ElseIf targetForm3 = True Then targetForm = 3 ElseIf targetForm4 = True Then targetForm = 4 ElseIf targetFormCU = True Then targetForm = 99 Else errForm = True End I ------------------- There has got to be an easier, maybe faster way of settin *targetForm*. please tell me there is. I can't imaging having man OptionButtons and having to do this *If ... ElseIf ... Else ... End If routine.. -- AMK ----------------------------------------------------------------------- AMK4's Profile: http://www.excelforum.com/member.php...fo&userid=1914 View this thread: http://www.excelforum.com/showthread.php?threadid=50628 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm OptionButtons | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
Choosing Only One Of Three OptionButtons | Excel Programming | |||
OptionButtons | Excel Programming | |||
optionbuttons | Excel Programming |