View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default 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]