Trouble with UserForm

[MDorsey]

I have programmed quite extensively in VB.net but VBA is new to me. I am trying to access the Textboxes (about 80 of them) from the main Userform inside a procedure. I am using VBA 7.0 and I was trying to pass the form as an argument. Well, needless to say, I couldn't get it to work. Am I on the right track or do I need to do something else, like pass the collection of controls, or some other way? I really don't want to pass each individual textbox to proocedure. Any help would be appreciated.
Thanks.

 

[tweedle]

Greetings, & Welcome.

Something like this may assist
(Passing the Control Array):

Usage within Form_Event:

Foo Me.Controls

'In a Module
Sub Foo(arrControls As MSForms.Controls)
For Each Control In arrControls
    With Control
        Debug.Print .Name
    End With
Next
End Sub