Determine VBA Form Control Type

[Annelies]

Hi

I have some code that loops through all controls on a form. I want to be able to determine what type (eg, Combobox, TextBox, CommandButton etc) each control is.

My code looks like:

Dim c as Control
For Each c In Me.Controls
If (c.?? = TextBox) Then
'Do something
End If
Next c

TypeOf doesn't work.
FormControlType property doesn't work.

Surely there must be an easy way to do this!?!

Any help gratefully received!

Annelies

 

[combo]

Use TypeName(ObjectVariable) function

combo

 

[TonyJollans]

TypeOf does work but you may need to qualify the type name to be sure you are checking the right one, for example

[blue]If TypeOf c Is MSForms.CheckBox Then [/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association