Thanks for the quick reply and the sample code. I've been playing with your sample code.

I've opted to use the Tab order code, but it's doesn't seem to save in the spreadsheet columns in tabindex order?
Not certain, but looks like it's saving in the order the controls were put on the userform.
Not the physical order of the controls on the userform but the time the control was created and added to the userform.

If I take your userform and add another textbox and give it a tabindex of 0, change the tabindex order of the original 2 textboxes to 1, 2 respectfully, it saves the new textbox that I added to the 3rd column of the spreadsheet, not the 1st like you would expect, based on the tabindex value.

Don't know if that's normal, or if it's supposed to follow the tabindex value of the control?
Chris

Your sample code modified with new TextBox control added with tabindex=0.
Get Data From All TextBoxes In All MultiPages Of A User Form.xls