You should be using the right textbox; instead of:
If Application.CountIf(.Range("E:E"), Me.TextBox1.Value) = 0 ThenIf Application.CountIf(.Range("E:E"), Me.TextBox16.Value) = 0 Then
You should be using the right textbox; instead of:
If Application.CountIf(.Range("E:E"), Me.TextBox1.Value) = 0 ThenIf Application.CountIf(.Range("E:E"), Me.TextBox16.Value) = 0 Then
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote