I need a message to pop up when there are no results in the autofilter selections.

[koneill828]

Hi everyone,

I recently created a directory where our attorneys can choose options from a drop down menu and Excel will autofilter and pull up the results that match with those options.

What I would like to do is, when no results match with the selections they choose, a pop up message that lets the user know, "No results found."

I know how to create a simple message box, but I am not sure how to link it with the autofilter so that the message pops up automatically when no results are found.

Currently the autofilter code is:
Sheet code:

Please Login or Register  to view this content.

Module code:

Please Login or Register  to view this content.

I am very very new to VBA. Thanks in advance!

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

[nigelog]

Untested as no workbook

Please Login or Register  to view this content.

[koneill828]

That didn't work, but thank you! I can't attach the file because it contains confidential information, but I can include a picture if that's helpful at all?

Attachment 653820

[nigelog]

Picture in this instance no good. Banner at top of page gives instruction on removing such data

[koneill828]

Here is an example without confidential information. The autofilter isn't working on it and I can't figure out why. The autofilter on my actual directory is still working as it should.

[koneill828]

Okay, example directory is attached and autofilter is working again.