ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving around an User Form (https://www.excelbanter.com/excel-programming/385201-moving-around-user-form.html)

Fredriksson via OfficeKB.com

Moving around an User Form
 
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1


Dave Peterson

Moving around an User Form
 
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" wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1


--

Dave Peterson

Fredriksson via OfficeKB.com

Moving around an User Form
 
Thank you

Dave Peterson wrote:
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.a...mming/200703/1



--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1



All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com