View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Heiko Heiko is offline
external usenet poster
 
Posts: 16
Default Identifying a Control Type

Hi,

If TypeOf c Is Listbox then
....
Heiko
:-)
"Chrissy" wrote:

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.