get name of combbox in a frame1 1

[sal21]

I need to loop all combobox in frame1 an d get the combobox

note:
in form have also frame2, but i need to loop combobox only in frame1

 

[strongm]

Here's a starting point for you:

[COLOR=blue]    Dim mycontrol As Control
    For Each mycontrol In Controls
        Debug.Print mycontrol.Name, TypeName(mycontrol), mycontrol.Container.Name
    Next[/color]

 

[strongm]

Was this of any use?