Looping through userform text boxes.

[mmartinez13]

I have a userform with 56 text boxes. I am wanting to enter data into these text boxes as I scan bar codes, and I only want to pass through 32 of the text boxes. The others are just for operator process validation.

Instead of writing code for each individual text box, is there a way i can start/end through the 32 text boxes I need? Loop?

Thanks in advance for any help I recieve.

 

[Andrew Poulsom]

If your TextBoxes are named TextBox1 to TextBox32:

Dim i As Long
For i = 1 To 32
'    Replace next line with your code
    MsgBox Me.Controls("TextBox" & i).Text    
Next i

 

[mmartinez13]

Andrew:

Thank you very much.