Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OptionButton value
I have a group of 3 OptionButtons ( No Lunch, 30 Minutes, 60 Minutes), What
I need is, if Cell 6 of the current row (rng(1, 6) ) is blank then No Lunch is set, or if 30 then 30 Minutes is set or if it is 60 well you get the point. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OptionButton value
Private Sub CommandButton1_Click()
If ActiveSheet.Range("A6") = "" Then OptNoL.Value = True ElseIf ActiveSheet.Range("A6") = 30 Then opt30L.Value = True ElseIf ActiveSheet.Range("A6") = 60 Then opt60l.Value = True End If End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OptionButton value
You could take another approach, link all 3 buttons to the same cell, say
A1, and add this formula to A1 =IF(F1="",1,IF(F1=30,2,IF(F1=60,3))) -- HTH RP (remove nothere from the email address if mailing direct) "Claud Balls" wrote in message ... Private Sub CommandButton1_Click() If ActiveSheet.Range("A6") = "" Then OptNoL.Value = True ElseIf ActiveSheet.Range("A6") = 30 Then opt30L.Value = True ElseIf ActiveSheet.Range("A6") = 60 Then opt60l.Value = True End If End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OptionButton | Excel Programming | |||
OptionButton | Excel Programming | |||
Better Way to Use OptionButton | Excel Programming | |||
Better Way to Use OptionButton | Excel Programming | |||
which optionbutton is on | Excel Programming |