Pre select a textbox in a userform

[UHsoccer]

When my userform is displayed, I would like to have the input field preselected. It is the same as using the Shift-Home key.

I current ly use a shortcut ( Ctrl-M ) to select the sheet and display the userform, as in

    Sheets("Select").Activate
    Call Worksheets("Select").CommandButton1_Click
    
    UserForm1.TextBox1.Select   ' NOT correct

The last line does not work, but it was my stab at the problem

Any ideas appreciated

 

[Norie]

How did you use the code I posted?