no tab index property in VBA for text fields

  • Thread starter Thread starter Kevin Mitchell
  • Start date Start date
K

Kevin Mitchell

Hello all,

I have created a microsoft excel program which uses visual basic text fields
on a worksheet. My problem is that when I hit the tab key I don't know how
to set the focus to the next text field without having to look at the
keyascii for every field. I know in VB6 there is a tab index property for
every text field but this doesn't exist in excel form fields. Can someone
please help shed some light on how to set a tab index in excel text fields?

Thanks,
Kevin
 
Not sure what you mean by "text fields".

Forms Toolbar has no Text Box

Controls Toolbar does have a Text Box but AFAIK tab does not work (?)

If you are using worksheet Cells you can control tabbing to some exten
by unlocking input cells and protecting the sheet. This works left t
right then down.

If you are using a Text Box from the Drawing Toolbar tabbing works lef
to right then down depending on where the top is.
One of the text boxes has to be selected first for this to work.

If you have set up a UserForm in the VB Editor tab order can be se
using View/Tab Order
 
Hi Brian,
Thanks for responding. I am using the constrols toolbar textbox. When I
place 2 text boxes on the form, I want to change the focus from text1 to
text2 when the tab or enter key is pressed but I can't seem to get this
functionality as I could if the text boxes were on a proper form. Can you
please help? Thanks. P.S. I don't know what AFAIK means.
 
Back
Top