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.
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.
Thanks for creating the thread for afrpompeia
To handle the Lines in your UserForm, you can use the Visible property :
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
Don’t have an account yet? Register yourself now and be a part of our community!