referencing form control labels in VBA

**kadams99** · 06-27-2012, 01:57 PM

I need to hide the labels on a sheet if a certain cell has a specific value. The labels are not activeX labels, but are the form control labels. I know how to loop through activeX controls. See code below. But how do I code this for the form control label?

   For Each OleObj In ActiveSheet.OLEObjects
      If OleObj.progID = "Forms.Label.1" Then
         OleObj.Object.Visible = False
      End If
  Next OleObj

**tlafferty** · 06-27-2012, 02:15 PM

For each ctrl in Userforms!Form1.controls
if ctrl.label = "test text" Then 'modify this line
ctrl.visible = False
End if
Next ctrl

**kadams99** · 06-27-2012, 06:54 PM

I'm a bit confused how to use Userforms!Form1.controls in code. The labels are on the worksheet not a form, so this didn't work in my code. I got a 'Type Mismatch' error.

Thanks.