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

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.

"Lin" wrote:

> 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

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.

"Lin" wrote:

> 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

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.

--
Rick (MVP - Excel)


"Lin" <(E-Mail Removed)> wrote in message
news:C35FC9EA-E282-4034-95DA-(E-Mail Removed)...
> 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