
Passing an Array of Controls to a Sub
Quote:
>How can I pass an array of controls (for instance, array of Label controls)
>to a Sub.
You can pass it "As Object" or "As Variant". Here's an example...
Private Sub ProcessControlArray(ctlArray As Variant) 'could be As Object
Dim ctl As Control
For Each ctl In ctlArray
'do something
Next
End Sub
...and in your main code...
ProcessControlArray lblInformation 'where lblInformation is a control array
Frank Carr