Hi guys,
I have an Userform that contain 10 TextBoxes, is there a way to loop into this textboxes, i tried:
and this:![]()
Dim textb As MSForms.TextBox For Each textb In UserForm1 MsgBox textb.Value Next textb
Both of the code are not working, is there a way that i can do this.![]()
Dim textb As String Dim i As Integer For i = 1 To 10 textb = "userform1.textbox" & i & ".value" MsgBox textb Next i
Thanks for your help.
Bookmarks