View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jnf40 jnf40 is offline
external usenet poster
 
Posts: 103
Default Userform Controls

I have a userform with 26 Labels, 13 TextBoxes and 2 CommandButtons. What I
want to know is if there is a loop code to loop through each control
regaurdless of it's type and set Enable to False according to the Controls
name? I have the Labels and TextBoxes named Cntrl1 thru Cntrl39.
Thanks