Userform Visible Property

afrpompeia · Jan 21st 2023

I don't know if it would be here.

Making a program in excel 2019 using vba,

I use labels as segments.

The delete routine does not work for LineLQ.

**Carim** · Jan 21st 2023

afrpompeia

Hi,

You should create your own thread ...

**Carim** · Jan 23rd 2023

rory

Thanks for creating the thread for afrpompeia

afrpompeia

To handle the Lines in your UserForm, you can use the Visible property :

Code

Private Sub cmdClear_Click()
Dim ctrl As Control
  For Each ctrl In UserForm1.Controls
      If TypeName(ctrl) = "Label" Then
        'Identify Lines and change Visible '
        If Left(ctrl.Name, 4) = "Line" Then
            ctrl.Visible = False
        End If
      End If
  Next ctrl
End Sub

Display More

Hope this will help

**Carim** · Jan 25th 2023

afrpompeia

FYI just marked your thread as solved

Userform Visible Property

Carim Jan 23rd 2023

Participate now!

Share