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
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
Peace of mind is found in some of the strangest places.
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.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
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.
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...
Peace of mind is found in some of the strangest places.
One other thing, when you click new on the user form it should remove the data in the user box but does not.
Peace of mind is found in some of the strangest places.