still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 774
- Office Version
- 365
- Platform
- Windows
Hi
I have a userform that after data is entered, an advance filter finds the results.
Is there a way to have a message box come up if no results are found?
If there are no results, BA3 (which is the start of the Extract range) will be empty
I tried using
On Error Go To errorline
Errorline: msgbox “ NO RESULTS”
But the msgbox comes up if BA3 has data or is empty
He’s the userform macro shortened for clarity
Chsavfind is the advance filter macro
mike
I have a userform that after data is entered, an advance filter finds the results.
Is there a way to have a message box come up if no results are found?
If there are no results, BA3 (which is the start of the Extract range) will be empty
I tried using
On Error Go To errorline
Errorline: msgbox “ NO RESULTS”
But the msgbox comes up if BA3 has data or is empty
He’s the userform macro shortened for clarity
VBA Code:
Private Sub CommandButton1_Click()
With TextBox1
ActiveSheet.Range("af3").Value = .Text
End With
Me.Hide
End With
chsavfind
Unload Me"
End Sub
mike