need to skip on enter

vanoskyj

Board Regular
Joined
Apr 20, 2004
Messages
54
I have drawn an example of my problem. In this example you will see that there are 6 textboxes (3 in each row). When the user is typing in the data and she only needs the first row I need to have her skip the remaining three text boxes and goto the total materials textbox. This cannot be done through tabbing over though because there are actually 8 rows in the actual userform. how can I go about this?

quantity | parts | amount
=======|=====|=============
txtb1 | txtb2 | txtb3
======|=======|=============
txtb4 |txtb5 | txtb6
=======|======|=============
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Kentman

Active Member
Joined
Apr 26, 2010
Messages
257
This should be in the 'Excel Questions' post area, not the technical posts.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,950
Messages
5,508,327
Members
408,679
Latest member
Daven13

This Week's Hot Topics

Top