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/

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/

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/