Search in subset of collection

[Pieterv]

Hi guys,

Does somebody knows if you can search for controls in a userform collection, like in:

/ Dim ctl as Control
/ For Each ctl In UserForm1.Controls
/"do action"


but can exclude one specific subset of the collection of the action ? Like the subset:

/ UserForm1.MultiPage1.Pages(2).Frame21.Controls

For example, is there a conditional statement which i can include like

/ if ctl.location = UserForm1.MultiPage1.Pages(2).Frame21.Controls then
/ "do nothing"

Thanks and kind regards,
Pieter

 

[Domenic]

Try...

    Dim Ctrl As Control

    For Each Ctrl In UserForm1.Controls
        If Ctrl.Parent.Name <> "Frame21" Then
            MsgBox Ctrl.Name
        End If
    Next Ctrl

Note, however, controls such as a MultiPage1 and Frame21 will not be excluded. If needed, you can loop through specific controls. For example, if you want to loop through textboxes...

    Dim Ctrl As Control

    For Each Ctrl In UserForm1.Controls
        If TypeName(Ctrl) = "TextBox" Then
            MsgBox Ctrl.Name
        End If
    Next