I have a userform that has some checkboxes. How do make it so that whe
the userform initializes checkbox1 is already checked

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

Hi,
You can initilaize checkboxes to being checked in 2 ways:
- in Design mode, select the checkbox. In the Properties window, set the Value property of the checkbox to True
(If the Properties window is not displayed, go to menu View Properties Window)
- at Run-time, in the _Initialize sub of the userfform:
Private Sub UserForm_Initialize()
CheckBox1.Value = True
End Sub
--
Regards,
Sébastien

You can set the Value property of the checkbox to True at design time.


Or at runtime :

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"ForSale " wrote in message
...
I have a userform that has some checkboxes. How do make it so that when
the userform initializes checkbox1 is already checked?


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