Private Sub UserForm1_Activate

should be
Private Sub UserForm_Activate

using the generic Userform

If you select your events from the dropdown, you won't have this problem.

--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
...

This doesn't seem to work:

Private Sub UserForm1_Activate()
Me.PrintHyperLinkOptionButton.Value = True
End Sub

Now I am still using the sub below and your refinement.
Cannot I not do this?

Sub AuditCell()


UserForm1.CircularityChkBx.Enabled = False
UserForm1.InputsChkBx.Enabled = False
UserForm1.ExternalLinkChkBx.Enabled = False
UserForm1.UniqueFormulasChkBx.Enabled = False

UserForm1.PrintColourMapOptionButton.Enabled = False

UserForm1.ComboBox1.Enabled = False

UserForm1.UniqueFormulasAdjustChkBx.Enabled = False

UserForm1.Show

End Sub



-----Original Message-----
Why not just use

Me.Optionbutton1.Value = True

in the Userform_Activate event?

But be aware, if you have a click event for that button,
it will be
triggered.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote
in message
...
I have a a form with Option Buttons. I want to load the
form with one of its buttons at TRUE. The following
below
does not work. The form loads with the option button
chosen. Whey is this

PrintHyperLinkOptionButton = True

UserForm1.Show

Thanks


.