Must open and close UserForm twice for the other codes in the "Open..." Macro to execute

Hello,

I have the following issue:

Whenever I open the UserForm1 it does not execute all the codes except for the code that actually makes it Show. I found that everytime I open it I have to close it again and then re-open it for the codes to actually execute.

The following code is what I´m currently using:

Please Login or Register  to view this content.

I´m thinking maybe there should be an ApplicationEvent or something in the beginning of the code?

Thanks in advance

Originally Posted by HaHoBe

Hi, tnuis,

if it´s a UserForm in VBA I´d expect you to use UserForm_Initialize or UserForm_Activate (behind the UserForm) instead of UserForm_Open (which isn´t present in my UserForm in VBA).

Ciao,
Holger

Hi HaHoBe,

I tried both UserForm1_Activate and also UserForm1_Initialize but both of them give me the same result. I still have to close and click the Macro Button twice for the codes to run

Any other suggestions?

Originally Posted by Winon

Hello tnuis,

I agree with HaHoBe. You may also want to select, Microsoft Visual Basic for Applications Extensibility 5.3

in the VBE under the Tools>References menu.

Regards

Hi Winon,

I would also agree With HaHoBe but the only problem is that it makes no difference. I´m still stuck With the same problem. I selected the Microsoft Visual Basic for Applications Extensibility 5.3 like you said......Why did you want me to do this? What difference is this supposed to make? Am I supposed to doe anything else aswell?
It is still not working I´m afraid.

Originally Posted by Andy Pope

Please Login or Register  to view this content.

The .Show will suspend execution. when you close the userform the information is then loaded. Because they is no code to unload from memory second time around the userform shows with values.

Thank you so much Andy, that simple little thing did the trick

I see what you are saying. Will look out for that in the future. Learning something New everyday, love it

Originally Posted by HaHoBe

Hi, tnuis,

there is only one Initialize-Event as well as one Activate-Event for each userform, and they all have the very same names as Norie stated: UserForm_xxx, nothing else.

Thanks, Andy, for the passing the information, I had missed the latter part of the code and certainly would not figured it out.

Ciao,
Holger

Ok thanks for the heads up HaHoBe