Cycle throught Text Boxes in UserForms

I have 10 text boxes in a multipage user form that I am trying to cycle though to put their input data onto my spreadsheet. The text boxes are named TestWord1, TestWord2, . . . TestWord 10. I have come up with the following code

Please Login or Register  to view this content.

I have tried multiple ways to get the value out of the "current" text box (last attempt shown in the TWord = Evaluate ... line, which results in a error code 2029?

I know i can do this with select case and have 10 cases, the first being Tword =TestWord1.Text, but I was hoping to loop through this - is there a way to get TWord to evaluate to TestWord1 -TestWord10?

Thanks in advance,

Tom

Please Login or Register  to view this content.

should do it.