Thread: textbox array
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
jimmy[_5_] jimmy[_5_] is offline
external usenet poster
 
Posts: 37
Default textbox array

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