intializing a user form in vba

[lezawang]

Hi
I created simple form (2 text boxes+ 3 cmd buttons). I wrote a code to show the form (no problem) an wrote another sub to initialized the form (not sure how important is that but I read somewhere that I need to do that). I put both sub in the same Module. I read that the UserForm_Intialize() should be called automatically after finishing sub callingform() but that did not happen to me. I stepped over the code but it will not move beyond End sub of Callingform() . Any help would be very much appreciated. Thanks


Sub callingform()
myform.show
End Sub

Sub UserForm_Intialize()
first.value="john"
second.value="smith"
End Sub

 

[CalcSux78]

Try changing Initialize to Activate.


Might help to read this article: https://excelmacromastery.com/vba-user-forms-1/

When you're calling a userform, there is a modal flag that will impact how the userform behaves once opened. The article explains the ins and outs of what's occuring.

 

[Fluff]

Do you have a userform called myform?
And is the

Sub UserForm_Intialize()

in the Userform module?

 

[lezawang]

Thanks all for the help. PLease see screen shot below. My user form called myform and the code Sub UserForm_Intialize() is in the Module1. Any help would be appreciated.

https://drive.google.com/file/d/1Dibjy338Gr4P36V7SDhQa4G45FqL8NPq/view?usp=sharing

 

[Fluff]

All userform code must be in the userform module.