User Form Tab Order

[Guest]

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

 

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

 

[Guest]

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

 

[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