Is it possible to add a parameter in the UserForm_Initialize() function ?

[MarieBocc]

Hello everyone,

So, yeah, the question is in the title. Can I for instance write something like
Private Sub UserForm_Initialize(rowCount As Integer)
and call it in my macro with
myControl.UserForm_Initialize(rowCount)
and expect it to work ?

Thanks you for reading,

Marie

 

[gallen]

In short no. I don't believe you can.

However you can add public variables to the form and then set them when you create the instance of the form.

 

[Fluff]

Another option would be to send the value to a control on the userform like

   UserForm1.TextBox1.Value = 123
   UserForm1.Show

or use the Tag property

   UserForm1.Tag = 123
   UserForm1.Show

 

[RoryA]

If you need the value to be available to the Initialize event, rather than say the Activate event, you'd need to use a public variable (declared in a normal module, not in the userform).