User Form Tab Order

E

Erik (AP Inc.)

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
 
B

Bob Phillips

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)
 
J

Jon Peltier

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
 
Top