View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Ref a Group of Controls

Another way might be to put the related controls in a Frame

Me.Frame1.Visible = bVis

You could disguise the frame by removing its caption and setting its border
colour to same as the form.

Regards,
Peter T


"Abdul" wrote in message
ups.com...
How i can refer a group of controls?

for eg. in mu userform when clicking a button i have to hide a few
labels, textboxes and comboboxes.

instead of saying textbox1 visible =false and combobox1 visible =false
etc to refere each control is there a way I can group them and refer
them in a single line?

thanks