Thread: Option Buttons
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Charles Harmon Charles Harmon is offline
external usenet poster
 
Posts: 48
Default 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.