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

--
Message posted from http://www.ExcelForum.com