Ref a Group of Controls

[Abdul]

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

 

[Zone]

Put a distinctive set of characters in the names of the controls you
want to make not visible, such as zz, so rename textbox1 textboxzz1,
for instance, and so on. Then you can refer to them like this:

Dim ctrl As Control
For Each ctrl In Controls
If InStr(ctrl.Name, "zz") > 0 Then ctrl.Visible = False
Next ctrl

James

 

[Peter T]

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