Tabbing in a user form

[austenr]

I have added a field to a user form. Tabbing through the fields is not a problem until I get to the new field. Tabbing through from the top it skips my new field. How can I get it to tab to the new field? Thanks

[Zack Barresse]

Hi Austen,

In your VBE looking at your Form, right click anywhere on the Form and select Tab Order. You can move Objects up/down.

[Jacob Hilderbrand]

Also look at the Properties for any object and look for the TabStop Property. Set this to False and the object will be skipped when you tab.

[austenr]

That took care of my tabbing problem. Thanks. Have another issue. On my user form my scrol bar is not working. There are plenty of rows to make it have to scrool but it seems to be disabled. Have attached my file. Help would be greatly appreciated.

Oops cant type today...

[austenr]

One other thing, when you click new on the user form it should remove the data in the user box but does not.