Hi friends,
In this code if the filter entry is not found then the message should pop up 'No match found" so that the user understand that no match found.
Please suggest me a code for it.
Thanking you in anticipation.
Please Login or Register to view this content.
Regards,
Mukesh
Hi mukeshbaviskar,
The below is the correct syntax for the MsgBox.
You also need to change the name of the Sub to something other than 'name'
And you were nearly there but needed 'Selection' before Autofilter.
Please Login or Register to view this content.
Remember you are unique, like everyone else
Hi noboffinme,
Thank you. Please explain me why the sub name should be change so that I would avoide such mistake in future. Actually the code is working fine only I want a little modification if the enter name is not found then the message should pop up 'No match found'. In this code the message didn't pop up if the entry name is not found. The message 'The filtered list is ready' is pop up in both situation. If entry is found and not found.
Thank you.
Regards,
Mukesh
I have a quick question for you.
You want to filter out the value in the whole range B7 - AB3000 that the user enters into an Inputbox.
Are all Cells in that Range populated?
Yes. The macro is working fine and filtering the name and populate the whole range.
Simply I want the code to display a message 'No match found' if the name is not found.
Thank you.
Mukesh
Hi mukeshbaviskar,
The below code will do what you've asked.
You need to make a couple of changes to your data though.
Define the Name of the Range of Cells 'B7:AB3000' as 'tSource'
Name your Worksheet "Sheet1"
The Column that will be searched for the Value you input will be the Third Column of your table.
As your data starts in Column 'B' the Third Column from there will be Column 'D'.
Let me know how you go.
Please Login or Register to view this content.
Hi
I'm getting error as follows:
run time error 1004 'Method Range' of object_Globle failed
Please suggest me a solution.
Thank you.
Regards,
Mukesh
At what line in the code does the error happen?
Hello Noboffinme,
The error happen in the following line.
Thank you.Please Login or Register to view this content.
Regards,
Mukesh
Have you done this step as requested?
Define the Name of the Range of Cells 'B7:AB3000' as 'tSource'
Hi Noboffinme,
No,Sorry! How to do it.
Thank you.
Regards,
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks