View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spencer Spencer is offline
external usenet poster
 
Posts: 29
Default UserForm Controls Collection

Is there a way to "capture" all of the controls on a form that are of a
certain type. for example. Change the forecolor of all labels to Blue.

with my naming conventions i could probably do this with some kind of loop
since all my labels' names start with "lab", but i dont know how to identify
them in the controls collection as a specific type of control.