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.


"BrianB " wrote in message
...
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 extent
by unlocking input cells and protecting the sheet. This works left to
right then down.

If you are using a Text Box from the Drawing Toolbar tabbing works left
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 set
using View/Tab Order.


---
Message posted from http://www.ExcelForum.com/