View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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/