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.
Any thoughts?

Answer

This is the best way to show your user form.

Private Sub CommandButton1_Click()
    UserForm4.Show
End Sub

(for formulas, depending on your country, you might have to change ; with , or the opposite

Other excel answers

 

 

You can find similar Excel Questions and Answer hereunder

1) How can I set up ListBox using VBA to allow users to select multiple values?

2) How can I filter and copy only filtered data using VBA?

3) How do I update my DropDown list whenever the sheet is activated?

4) How to concatenate strings in vba in Excel

5) I have a macro that takes a lot of time for execution - how can I keep the user informed that the macro is running?

6) How to use the trace error function in VBA

7) How can I dynamically add series to an existing chart using VBA?

8) Vba length of an array in Excel

9) How can worksheet functions be accessed in VBA?

10) How can I hide a sheet completely from users (the sheet should not even appear in Unhide dialog box)?

 

Here the previous and next chapter