Userform initialize vs userform show in Excel
I am unable to get the Userform Initialize function to work.
I have a commandbutton on Userform4 which I want to use to launch Userform2. I can launch Userform2 using the Show command, but then it bye-passes the Userform2_Initialize() routine (shown below).
I have been told not to put the "2" after "Userform" in the Initialize sub routine, but this does not work either.
This is the best way to show your user form.
Private Sub CommandButton1_Click()
(for formulas, depending on your country, you might have to change ; with , or the opposite