Equivalent of Form_Load in UserForm
When I launch a user form I want the contents of a variable to be in a text box by default. In VB I would do this in Form_Load. Had anyone figured out how to set properties on the load of a user form?
Re: Equivalent of Form_Load in UserForm
Open the Form and View->Code and use the UserForm Initialize or Activate function.
Or dynamically from the calling script. Let's say you have
Set myform = New SomeUserForm
myform.Label7 = "some dynamic text"