How to initialize a userform from different places in a sub

**crissc** · 02-17-2020, 12:51 PM

Good day,

I have googled and tried various solutions, vainly.

I am looking for a solution how to initialise a Userform from 2 different subs. The Userform is filled dynamically depending on the content of the sheet List.

Userform initialise code:

Please Login or Register  to view this content.

Sud procedure 1

Please Login or Register  to view this content.

the second sub procedure code is somehow

Please Login or Register  to view this content.

Following some inputs found on the web, I have done many tests, from which:

I have changed the Private to Public without success.
I have tried to integrate a Application.Run "'" & UserForm1.Name & "'!UserForm_Initialize"
I have tried to define the following in the "main" subs:

Dim userForm1 As UserForm1
Set userForm1 = New UserForm1

but I don't manage to get any result.

I can handle the subs and userform_initialise alone (without linking the userform_initialise to the subs). The Private sub userForm1_initialise () works fine alone, after it is shown, the user will perform a selection of the check boxes and click a button to use this selection and create a new sheet. The selected values are correctly managed afterwards.

Could someone help and explain how I can manage to initialise the userform from the sub procedures?

Thanks in advance for any support you could provide me.
Crissc

**torachan** · 02-17-2020, 01:33 PM

Within your UserForm code.

Please Login or Register  to view this content.

so that it can be called from outside of the UserForm
Externally from a module

Please Login or Register  to view this content.

If you have already loaded the UserForm previously then

Please Login or Register  to view this content.

This automatically calls the Initialize event when opening the form

**rorya** · 02-17-2020, 04:14 PM

Just as a general comment, event procedures are designed to run automatically in response to things occurring (e.g. Initialize runs whenever an instance of your class/form is created). They are not really intended to be called from other routines, so if you find yourself needing to do that, you should probably move your code to another routine and call that from the Initialize event and from wherever else you need it.

**torachan** · 02-18-2020, 04:19 AM

Although having given the O.P. an answer I fully agree with @rorya (what the O.P. is doing should not be encouraged).
My response should have been O..M.G. what are you doing - start again - instead of prolonging the agony.
torachan.

**Kyle123** · 02-18-2020, 04:37 AM

It should be noted that the OP doesn't actually have an initialize event, s/he has a slightly misleading sub named userform1_Initialize in a module...

**crissc** · 02-20-2020, 10:15 AM

Hello every one and thanks for the support,

Unfortunately, I can't menage to use the solution shared by torachan.
I get an error saying: Run-time error: '91' - Object variable or With block variable not set.

I don't understand this error as I do not have a With block in this part of the code and the code "UserForm1.UserForm_Initialize" does not use a variable.

Attachment 663711

In addition: O.P. for outside process? or something else? (sorry for not understanding)

**rorya** · 02-20-2020, 10:17 AM

OP = Original Poster (i.e. you

)

I'm not sure what that attachment is meant to be but the link doesn't work.

**crissc** · 02-21-2020, 06:07 PM

The attachement is the error popup (second try here) => in Excel 2016 (office 365)

The error "Compilation error" (in French is in Excel 2013 (using the same code)