View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Kilmer[_2_] Bob Kilmer[_2_] is offline
external usenet poster
 
Posts: 71
Default VBA - Option Button

MacroName()
OptionButton1.Value = True
'more code,...
End Sub

'If the option button is in a form, use:

Private Sub UserForm_Initialize()
OptionButton1.Value = True
End Sub


"ajliaks " wrote in message
...
Hi

I have option buttons called "one" and "two"

How can I made option button "one" be preselected by defect?

(when I run the macro, obtion button "one" must appear selected.

Thanks.


---
Message posted from http://www.ExcelForum.com/