user form start field
 

I have a user form with several text boxes but when I start executing the
form the cursor starts in the wrong text box... how do I change to the place
I want it to start....?

It start on textbox2 but I need it on textbox 1...
I have a second form and it does start on text box 1 but I do not know how
to control this.

user form start field
 

In the Userform design mode, right click the text box and select properties.

You will find 3 properties. Tab Index, TabKeyBehaviour and TabStop

TabIndex starts at zero for the first stop. Set the Numeric 0 to 2 for each
of the 3 textboxes in the required order.

TabKeyBehaviour = False. Tab advances to next control.
TabKeyBehaviour = True. Tabs within the control. (Use Enter to advance to
next control)

TabStop = True. Cursor will stop in the control with Tab or Enter.
TabStop = False. Cursor will skip the control with Tab or Enter but you
can still select the control with the mouse.

--
Regards,

OssieMac


"Alberto Ast" wrote:

I have a user form with several text boxes but when I start executing the
form the cursor starts in the wrong text box... how do I change to the place
I want it to start....?

It start on textbox2 but I need it on textbox 1...
I have a second form and it does start on text box 1 but I do not know how
to control this.

user form start field
 

Hi Alberto

you can add setfocus property to the textbox where you want the cursor on
form load event. For example you want cursor on textbox1 in Userform1

Userform_initialize()
Userform1.textBox1.SetFocus
End Sub

Regards
Om
"Alberto Ast" wrote:

I have a user form with several text boxes but when I start executing the
form the cursor starts in the wrong text box... how do I change to the place
I want it to start....?

It start on textbox2 but I need it on textbox 1...
I have a second form and it does start on text box 1 but I do not know how
to control this.