VBA - Option Button

  • Thread starter Thread starter ajliaks
  • Start date Start date
A

ajliaks

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing preselected pages in Excel 2003 4
macro to select option button in option group 2
Re: Reference must be to a macro sheet? 0
Bizarre option button behavior 2
macro using forms button 1
How to enable "Links" when copy a worksheet (with buttons on it) to anew book 2
OPtion Button 6
Get value of Option Button in Excel 2008 for Mac 1

Back
Top