View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chrissy[_4_] Chrissy[_4_] is offline
external usenet poster
 
Posts: 101
Default Identifying a Control Type

How do I identify what type of control I have on a form

Dim c As Control

For Each c In UserForm1.Controls
if c (is a text box) then
some code
Next c

What goes in the brackets?
Chrissy.