Tab Order for an Excel Form

  • Thread starter Thread starter NMC
  • Start date Start date
N

NMC

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,
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?
Click to expand...

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing tabbing order in Userforms 2
Tab between ActiveX controls on an Excel worksheet 4
Tabbing between textbox's 3
Changing Tab order - easier method?? 3
Change Tab Order of UserForm TextBoxes Conditionally 2
How to code tab order for Controls in Excel forms 3
Tab Index Not working? 1
Set tab order for textboxes 4

Back
Top