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
=======|======|=============
quantity | parts | amount
=======|=====|=============
txtb1 | txtb2 | txtb3
======|=======|=============
txtb4 |txtb5 | txtb6
=======|======|=============