Hi. Can anyone suggest a plan of attach.



I have a userform that has three fields at the top which are entered only once. After that there are 20 textboxes below that that will be entered for each record. Once each record is completed, the next tab or focus will go to the 1st textbox below the three batch text boxes which will not change but remain the same for all records (20 textboxes equal one record) below it. There is an add button which allows me to add the record to a spreadsheet once the 20th textbox is filled. Even though the three batch fields remain static after the initial entry, they will also be copied into the first three columns of the data sheet with the additional 20 text boxes into the next 20 colmuns for a total of 23 columns of data added to the worksheet.

Currently, i have all 23 text boxes working fine, but the tab starts with the 1st textbox or the 1st of the three batch fields which are not needed to be entered each time ....how can i make this happen...thank.s