Looping Names in VBA

[LSanders]

I have a series of Text Boxes in a User Form with the same name but sequential numbers at the end. I would like to create a loop that goes to each text box and retrieves the informtion.

The problem is concatenating the name with the numbers, as VBA doesn't like to do it with User Forms like it does with Dialog Boxes. Thanks for your assistance.

[dk]

You can loop through all controls on a form using something like this. If you are unable to modify it to suit your needs then please repost:-

Private Sub CommandOK_Click()
Dim ctl As MSForms.Control
For Each ctl In Me.Controls
If TypeName(ctl) = "TextBox" Then
MsgBox ctl.Name & " contains the text """ & ctl.Text & """"
End If
Next ctl

End Sub

HTH,
Dan