Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Buttons
I have 3 option buttons on my userform:
No Lunch, 30 Minutes, 60 Minutes I do not seem to know how to group these 3 buttons together so that I can set 30 minutes as the default and selecting one of the others will clear the default. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Buttons
You ou can give the three buttons the same GroupName (in the Properties
window) or you can place them all in a Frame control. This ensures that only one member can be selected. Change the Value property of the default button to True. -- John Green Sydney Australia "Patrick Simonds" wrote in message ... I have 3 option buttons on my userform: No Lunch, 30 Minutes, 60 Minutes I do not seem to know how to group these 3 buttons together so that I can set 30 minutes as the default and selecting one of the others will clear the default. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Buttons
Hi,
You need to set the value of the button to true. IE: Userform1.Optionbutton2.value = True You can use this code when you init. the userform. "Patrick Simonds" wrote in message ... I have 3 option buttons on my userform: No Lunch, 30 Minutes, 60 Minutes I do not seem to know how to group these 3 buttons together so that I can set 30 minutes as the default and selecting one of the others will clear the default. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Buttons
Thanks guys for the quick response.
"Charles Harmon" wrote in message ... Hi, You need to set the value of the button to true. IE: Userform1.Optionbutton2.value = True You can use this code when you init. the userform. "Patrick Simonds" wrote in message ... I have 3 option buttons on my userform: No Lunch, 30 Minutes, 60 Minutes I do not seem to know how to group these 3 buttons together so that I can set 30 minutes as the default and selecting one of the others will clear the default. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Buttons
Figured it out:
If OptionButton1.Value = True Then rng(1, 12) = TimeSerial(0, 0, 0) ElseIf OptionButton2.Value = True Then rng(1, 12) = TimeSerial(0, 30, 0) ElseIf OptionButton3.Value = True Then rng(1, 12) = TimeSerial(0, 60, 0) End If "Patrick Simonds" wrote in message ... Thanks guys for the quick response. "Charles Harmon" wrote in message ... Hi, You need to set the value of the button to true. IE: Userform1.Optionbutton2.value = True You can use this code when you init. the userform. "Patrick Simonds" wrote in message ... I have 3 option buttons on my userform: No Lunch, 30 Minutes, 60 Minutes I do not seem to know how to group these 3 buttons together so that I can set 30 minutes as the default and selecting one of the others will clear the default. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Option Buttons | Excel Discussion (Misc queries) | |||
yes/no option buttons | Excel Discussion (Misc queries) | |||
help with option buttons | Excel Programming | |||
Option Buttons | Excel Programming |