setting focus with click of command button

At the Bottom of your code for CommandButton2 on the Userform add this line:

Me.ComboBox1.SetFocus

Hope it helps!

I just had another look at your Userform. It seems that you expect CommandButton2 to handle a magnitude of variables.

Best would be to Create a "Start" Button for each "Multiple" Sheet in your Userform, and add code to each one such "Start" Button to take care of its own procedure. Of course you would also have to add code to "Hide" the other two Buttons when any one of the other three is "Active".

Hello James,

If you do what I gave you in Post#2, CommandButton2 works just fine with Page 1 of the Multi-Page Userform. To keep it simple, and easy to code & maintain, it would be best if you created a seperate such CommandButton, each with its own unique code, for each one of the remaining individual pages of the Multi-Page Userform.(See my last post-#3)

You may stack these CommandButtons on top of each other, and simply control its appearance/s with Visible=True or False. To the user it will appear as just one Button.

You need to have the correct tab active

    Me.MultiPage1.Value = 0
    Me.ComboBox1.SetFocus

PS It would also be polite to respond to replies you get.

The .TakeFocusOnClick property of CommandButton2 should be False, if it is going to sent the focus to another control.

This snippet can be edited when Page3 gets some controls.

    With Array(ComboBox1, ComboBox5, ComboBox1)(MultiPage1.Value)
        .SetFocus
    End With

The array has to list a "starting" control for each page of the Multipage.

Thank you all who are helping with this but I am having real problems getting to grips with it. I will be returning to this problem in due course.
Until then if i leave "race1" to the front in the editor window it automatically focuses on the combobox1

Thankyou for your time