Moving around an User Form

[Fredriksson via OfficeKB.com]

I have an User Form in which a user input data. The first object that I would
like my user ti input or select data is a combo box then I have 2 text boxes
following.

When my User Form opens it defaults the cursor on the first text box by
passing the combo box.

I would like the curser to default on the combo box.

How do I control the movement of the cursor as an user enters data in the
user form

Thanks

 

[Dave Peterson]

Each control on your userform has a .tabindex property and a .tabstop property.

Try putting them in the order you like.

 

[Fredriksson via OfficeKB.com]

Thank you

Each control on your userform has a .tabindex property and a .tabstop property.

Try putting them in the order you like.

I have an User Form in which a user input data. The first object that I would
like my user ti input or select data is a combo box then I have 2 text boxes

[quoted text clipped - 13 lines]

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200703/1