User Form Tab Order
 

I have created several user forms in Visual Basic and when I run them in
Excel the Tab order is odd. It dosent go right to left top to bottom. It
jumps all over my sheet. Is there a way to make it go in the standard order?

Thanks
Erik

User Form Tab Order
 

Each control has a tabIndex property. Set these in your required order.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Erik (AP Inc.)" wrote in message
...
I have created several user forms in Visual Basic and when I run them in
Excel the Tab order is odd. It dosent go right to left top to bottom. It
jumps all over my sheet. Is there a way to make it go in the standard
order?

Thanks
Erik

User Form Tab Order
 

Thank you, I forgot to change this in the frame as well as the text box.

"Bob Phillips" wrote:

Each control has a tabIndex property. Set these in your required order.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Erik (AP Inc.)" wrote in message
...
I have created several user forms in Visual Basic and when I run them in
Excel the Tab order is odd. It dosent go right to left top to bottom. It
jumps all over my sheet. Is there a way to make it go in the standard
order?

Thanks
Erik

User Form Tab Order
 

You can also right click on the form to bring up a dialog which lets you
move all of the items up and down in the tab order.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Bob Phillips" wrote in message
...
Each control has a tabIndex property. Set these in your required order.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Erik (AP Inc.)" wrote in message
...
I have created several user forms in Visual Basic and when I run them in
Excel the Tab order is odd. It dosent go right to left top to bottom. It
jumps all over my sheet. Is there a way to make it go in the standard
order?

Thanks
Erik