PDA

View Full Version : [SOLVED] Tabbing in a user form



austenr
04-25-2005, 09:44 AM
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
04-25-2005, 09:53 AM
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
04-25-2005, 10:45 AM
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
04-25-2005, 12:34 PM
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
04-25-2005, 03:05 PM
One other thing, when you click new on the user form it should remove the data in the user box but does not.