Sorry Tim, here's the original message:
AMK4 Wrote:
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 ... En
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