Thanks...but how to group them into an array?
How to code in the 'do something else ?
"merjet"
egroups.com...
One can make control array in VB (each control has the same name and
an index, and Index is a Property). Excel VBA (2003 at least) does not
offer this.
You can loop through all Textboxes on a UserForm like this:
For Each c In Me.Controls
If TypeName(c) = "TextBox" Then
Debug.Print c.Name
'do something else
End If
Next c
End Sub
Hth,
Merjet