I have a .xlt with Textboxes on it and I want to set the
tab order of these text boxes. I've tried using the
TabIndex property but keep getting an error that
the "Object does not support this property or method". Am
I missing a reference to be able to use this?

Thanks,
NMC

Hi NMC,

NMC wrote:
I have a .xlt with Textboxes on it and I want to set the
tab order of these text boxes. I've tried using the
TabIndex property but keep getting an error that
the "Object does not support this property or method". Am
I missing a reference to be able to use this?

Tab orders are not supported when TextBoxes are placed directly on a
Worksheet. If you are using TextBoxes on a UserForm, then you can use the
TabIndex property of each control to set the tab order.

If you want to set tab order on a Worksheet, you can do it with VBA code,
but it's not a simple thing to set up.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Hi

Did you try to tab between the textboxes as is ? If they're on a worksheet
then you can't. No tab, no tab order.

HTH. Best wishes Harald

"NMC" skrev i melding
...
I have a .xlt with Textboxes on it and I want to set the
tab order of these text boxes. I've tried using the
TabIndex property but keep getting an error that
the "Object does not support this property or method". Am
I missing a reference to be able to use this?

Thanks,
NMC