Loop over selected controls on a form

[Bengt]

I have a Userform with a number of text boxes and some command buttons. What is the easiest way to write a loop so that I can loop over all textbox controls (or command controls for that matter). Is there a collection of certain types of controls that can be used?

Bengt

 

[Andrew Poulsom]

A UserForm has a Controls Collection, so:

    Dim Ctrl As Control
    For Each Ctrl In UserForm1.Controls
        MsgBox TypeName(Ctrl)
    Next Ctrl

 

[Bengt]

I knew there was a simple solution. Thanks a lot.

Bengt