Form with tab stop help

[orozvik@yahoo.com]

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

[NoSparks]

If I follow what you are wanting, in the exit event of, lets say textbox4, set the tabstop for each of the first 3 textboxes = false.

[orozvik@yahoo.com]

Hi Sparks. Thanks for the reply..... im not sure this works....it sounds good, but setting the tab stop for the first four records to 0 does not allow me to enter them one after the other by entering or hitting the tab stop.

I've attached a spreadsheet showing the form and the fields along with a brief description of what i am trying to get the form to do in the right margin.....thank.s allllll really looking for a solution here.

[NoSparks]

There's your problem.... macros won't run in an .xlsx file

set the tabstop for each of the first 3 textboxes = false <> setting the tab stop for the first four records to 0

[orozvik@yahoo.com]

Hi Sparks....i set the tabstop=False as in the following example under the exit event for each of the first four text boxes in the Batch group:

Me.Controls("txtDivision").TabStop = False

They are still numbered in the properties window with tabIndex from 1 to 4 and their tabStop property is set to False.

I assume after i tab through each of the first four batch-textboxes the exit even of each will set the tab stop to false and when i return to the beginning tabstops 1-4 will not take place and the focus will go to tab 5 which is the first with the tabstop set to True.

Does this sound like i am on course?

If so, this works, but for some reason the tab keeps coming back to the fourth text box instead of the fifth even when i have the textbox exit event change the textbox property to false.

[NoSparks]

OK, lets try this again.
You don't need to do anything with regards to tab stops or tab index.

At the end of your Add button's procedure put Me.Controls("where ever you want to start at").setfocus and things will just carry on as per normal from that point on.

If this doesn't fix you up, post a workbook a person can actually work with and I'll do it for you.

[orozvik@yahoo.com]

Thanks Sparks...you solved it......i appreciate you taking the time and hanging on with me......Thank.s!!!