unhide controls within a frame?

[kbishop94]

I'm trying to get my userform to hide all controls when it opens (Userform_Initialize) EXCEPT for those within a frame.

Unfortunately, this doesn't work:

For Each ctl In Me.Controls
    ctl.Visible = False
        If TypeName(ctl) = "Frame1" Then ctl.Visible = True
Next ctl

Nor does this (no error when I replace the line of code with this code, but it still remains hidden):

If TypeName(ctl) = "Frame1" Then ctl.Frame1.Visible = True

The controls inside Frame1 remain hidden.. The code hides all the controls regardless of whether its in Frame1 or not...... ?

Thanks in advance for any help.

 

[Micron]

One way would be to use the .Tag property for frame enclosed controls. In an If block, check if your Tag property has any value at all (or a specific value if need be) and code accordingly. Perhaps

If TypeName(ctl) = "OptionButton" And ctl.Tag = "myTagValue" Then
  ctl.Visible = True
Else
  ctl.Visible = False
End If

You didn't say what the type is, so I used option button. If there are several types and they're the only one with .Tag property values, then you don't need to specify the type.

 

[kbishop94]

One way would be to use the .Tag property for frame enclosed controls. In an If block, check if your Tag property has any value at all (or a specific value if need be) and code accordingly. Perhaps

If TypeName(ctl) = "OptionButton" And ctl.Tag = "myTagValue" Then
  ctl.Visible = True
Else
  ctl.Visible = False
End If

You didn't say what the type is, so I used option button. If there are several types and they're the only one with .Tag property values, then you don't need to specify the type.

Awesome. Thank you... I'll give it try after a bit and I'll let you know.

 

[kbishop94]

One way would be to use the .Tag property for frame enclosed controls. In an If block, check if your Tag property has any value at all (or a specific value if need be) and code accordingly. Perhaps

If TypeName(ctl) = "OptionButton" And ctl.Tag = "myTagValue" Then
  ctl.Visible = True
Else
  ctl.Visible = False
End If

You didn't say what the type is, so I used option button. If there are several types and they're the only one with .Tag property values, then you don't need to specify the type.

Thank you, Micron. That worked and did exactly what I needed it to. Not only that, but it made me realize how assigning tag values to other controls in separate frames can allow me to do a couple other things that I was struggling with (like having a single checkbox to control the value of all other checkboxes within a specific frame. )Thanks again!