Create your label4 at design time and set the visible property to false Then try this code
Private Sub ComboBox1_Click()
If Application.WorksheetFunction.CountIf(Worksheets("Sheet1").Range("C2:C800"), ComboBox1.Text) > 0 Then
If Application.WorksheetFunction.CountIf(Worksheets("Sheet1").Range("D2:D800"), ComboBox2.Text) > 0 Then
Me.Label4.Visible = True
Else
Me.Label4.Visible = False
End If
End If
End Sub
Private Sub ComboBox2_Click()
If Application.WorksheetFunction.CountIf(Worksheets("sheet1").Range("C2:C800"), ComboBox1.Text) > 0 Then
If Application.WorksheetFunction.CountIf(Worksheets("sheet1").Range("D2:D800"), ComboBox2.Text) > 0 Then
Me.Label4.Visible = True
Else
Me.Label4.Visible = False
End If
End If
End Sub
Bookmarks