I
iwrk4dedpr
Greetings,
Use the following code to loop through controls on a userform
Sub ReadAllTextboxes()
Dim formControl As Control
For Each formControl In UserForm1
If TypeName(formControl ) = "TextBox" Then
. . . Your Code Here To Test Value
End If
Next formControl
End Sub
This should work for you
Use the following code to loop through controls on a userform
Sub ReadAllTextboxes()
Dim formControl As Control
For Each formControl In UserForm1
If TypeName(formControl ) = "TextBox" Then
. . . Your Code Here To Test Value
End If
Next formControl
End Sub
This should work for you