You can initialize controls in a procedure before you show a form, or you can add code to the Initialize event of the form. All controls have a predefined set of events. For example, a command button ...

Add Procedure dialog box Inserts a new Sub, Function, or Property procedure. Allows you to set the scope to public or private, and make all local variables in the procedure static. Add Watch dialog ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.