Simple Hide-Unhide?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a number of controls (without sequential names) which I would like to
make visible and accessible after a particular field has been filled. Is
there any way other than setting each control to Visible = True (or Enabled =
Yes...) individually to achieve the same effect?

Group selections do not have a name that I can see. It also seems that a
large filled box cannot assigned "Send to Back" from VBA. Any other trick?

Thanks in advance.
 
Hi David,

Two techniques:

1) Put a filled shape over the controls and manipulate its Visible property
instead of sending it to back.

2) Put a particular value in the Tag property of each control that you want
to hide/unhide, and then do something like

For Each C in Me.Controls
If C.Tag = "XXX" Then C.Visible = True
Next
 
Back
Top