ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tab Order for an Excel Form (https://www.excelbanter.com/excel-programming/308564-tab-order-excel-form.html)

NMC

Tab Order for an Excel Form
 
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

Jake Marx[_3_]

Tab Order for an Excel Form
 
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]


Harald Staff

Tab Order for an Excel Form
 
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





All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com