Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form movement
I have a user form that i created and it works fine, except when the
form is open and i tab to move from field to field, it skips over the combo boxes to the text boxes and cmd buttons first, then back to the combo boxes. is there something i can do to have it not skip over the combo boxes? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form movement
The tabbing order of the controls on the form is control by the
TabIndex property value of each control. By default, the TabIndex numbers are in the order in which the control were created, not by their order on the form. With the form open in design view in the VBA editor, right-click the form and choose Tab Order. In this dialog, you can move controls up or down to change the tab order. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Zygoid " wrote in message ... I have a user form that i created and it works fine, except when the form is open and i tab to move from field to field, it skips over the combo boxes to the text boxes and cmd buttons first, then back to the combo boxes. is there something i can do to have it not skip over the combo boxes? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form movement
Hi Zygoid
Look a the Tabindex and Tabstop properties of each control in your Userform -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Zygoid " wrote in message ... I have a user form that i created and it works fine, except when the form is open and i tab to move from field to field, it skips over the combo boxes to the text boxes and cmd buttons first, then back to the combo boxes. is there something i can do to have it not skip over the combo boxes? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
user form | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How do I set up top to bottom movement for a Form with two column | Excel Worksheet Functions | |||
user form | Excel Discussion (Misc queries) | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |