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