UserForm textbox in focus with cursor. How?

[vandan]

This seems like a real beginner question but i have not been able to find the answer. i have a User form that has 1 textbox and 3 buttons. What i would like is that when the UserForm is launched that the textbox be in focus with the cursor ready. i can have the textbox in focus but the part that i can not do is have the cursor ready. i want to launch the UserForm and be able to start typing without having to select the textbox with the mouse.
thanks for you help,
Dan.

 

[lenze]

Hi Vandan. Welcome to the board.

Try this

Private Sub Workbook_Open()
UserForm1.Show
UserForm1.TextBox1.SetFocus
End Sub

 

[Andrew Poulsom]

Like this:

TextBox1.SetFocus
TextBox1.SelStart = 0

 

[vandan]

the setfocus command is what i was using it will put the textbox in focus but it will not give me the cursor. any ideas?
Dan.

 

[Andrew Poulsom]

See my solution.

 

[vandan]

the SelStart did not work either.

 

[Andrew Poulsom]

It works for me - I get a flashing vertical cursor.

 

[lenze]

Works fine for me too. Maybe you should check the TextBox Properties.

 

[vandan]

i tried it in a new worksheet with a new userform and it does work it must be something that i am doing in the userform code to lose focus i will work on it thanks.
Dan.