Creating a warning message if a filter doesn't exist.

[Stale_Buns]

Hey guys, so I'm looking to add a little clause at the end of some of my macros.

First, all the macros due is apply some filters to a slicer. For example:

"Shipment late" = True
"Shipment verified" = False....

Etc. Etc.

What I'd like to do, is add a lump of code at the end that provides a message if the filters don't exist. For example, if I wanted to click the button that showed me which parts are running late, but NO Parts are running late, it would just say "No late parts found."


The way my macros work is that I have a column which decides, using IF formulas, if a part is late. So - Is it possible to write some VBA that either A: Checks the slicer for the late option or B: Checks the column where the formula is (Let's just call it 'A' for now)

Thanks in advance!

[dOOb]

Please Login or Register  to view this content.

[Stale_Buns]

Thanks for the reply! At the moment I get the error message "Can't find project or library" and it highlights the "CountIf"

Any ideas? Also, for ease of swapping things in correctly, could we write it as if the column was A and the phrase "Late Part"?

For example, I re-wrote it like so, but I am not sure if the format is correct! (I'm very new to VBA)

If CountIf(Columns("A:A"), "Late Part") = 0 Then MsgBox "No late parts found."

[Richard Buttrey]

I think Doob probably expected you to preface the Countif. i.e.

Please Login or Register  to view this content.

[Stale_Buns]

Thanks! Made some progress that way. I'm trying to get it to work for multiple options, but it seems to be making a message box every time (even if the options exist).

Here's what I've got written out at the moment (Yes, U is definitely the correctly column and yes, the text in quote marks is exact i.e. same number of spaces etc. )

Please Login or Register  to view this content.

[dOOb]

try this:

Please Login or Register  to view this content.

[Stale_Buns]

I'm about to leave the office, but this looks like it has worked, I will double check tomorrow and return to close (Or ask another question!)

Thanks

[Stale_Buns]

Not sure how I close a thread... But all is well!