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
|