Index Order For Controls

The attached spreadsheet has a form that collects data in 35 different text boxes. The update spreadsheet button then puts the data in the spreadsheet. The problem I'm having is the second line of the transfer should be in order of length which I thought would be taken care of by the tab index number. It seems to put it out in a random order (5-10',4-2',15-30',5-1') instead of (5-1',4-2',5-10',15-30').

I've read something of birth order but I'm not sure where to find it. If someone could take a look and see if there is a solution for this, I'd appreciate it.

Hello Excellant,

Here is the updated version of the "Test" button. This will display the entries in order.

Please Login or Register  to view this content.