How to code tab order for Controls in Excel forms

L

Lin

Hi

I have an excel worksheet forms with Text box and combo box Controls. Ho can
I create tab order for them? Any help really appreciate.

Thanks,
Lin
 
J

JLGWhiz

This is from the VBA help file.

Set the tab order using the Tab Order dialog box



Make sure no controls are selected.

1. Right-click in the form, but not on a control.

2. From the shortcut menu, choose Tab Order.

3. Select the name of a control you want to reposition in the tab order.

4. Choose Move Up or Move Down until the control name is in the appropriate
position in the tab order.
 
J

JLGWhiz

If you want to do it by code, then use the Tab Index property (forms). But
unless you are creating the form by code, it is a lot more efficient to set
it manually.
 
R

Rick Rothstein

Select each control one at time in the REVERSE order you want them and set
the Tab Index to 0 with each selection (yes, zero each time)... when you are
done, the Tab Indexes will be in the correct order.
 
Top