Thread: Option Buttons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Green[_4_] John Green[_4_] is offline
external usenet poster
 
Posts: 47
Default 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.