Thread: Option Buttons
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
 
Posts: 258
Default 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.