Excel - Detect type of object on UserForm

[oneshadow]

I have 2 textboxes and 1 combo on a form and I would like to loop for every object on form. If it is a textbox then I will do something.

In VB it will be like:

Dim obj As Object
For Each obj in Form1
If TypeOf obj Is TextBox Then
'...
End If
Next

In VBA, TypeOf method returns the object name.

Q: How can I detect object type?
Thanks in advance

 

[JustinEzequiel]

This works for me

Dim oControl As Control

For Each oControl In Me.Controls
If TypeOf oControl Is TextBox Then
Debug.Print oControl.Name
End If
Next oControl