Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Not Found Error Msg Help

Status
Not open for further replies.

wiginprov

Technical User
May 5, 2001
35
US
I have a macro that searches a database for a tax id number. I need an error message if the tax id number is not found. How do I do that? Here is my syntax:


Dim strMessage As String
strMessage = Application.InputBox("ENTER TAX I.D. NUMBER (Example: ###-##-####)", "SEARCH FOR TAX ID#")
Let ActiveSheet.Cells(4, 22) = strMessage

Range("A7:A10030").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Range("V3:V4"), Unique:=False


Many thanks.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top