Close Input Box and do not filter when cancel selected

[jiminic]

Hi Everyone

I am using the piece of code below to allow users to filter columns via a message box.

Please Login or Register  to view this content.

The problem I am having is that if cancel is selected, the filter will still run and will filter just for blanks. Does anyone know what would be the best way to exit the sub without having the filter run?

Thanks

[Jokacave]

Hi jiminic

Try this code

Please Login or Register  to view this content.

[jiminic]

Hi Jokacave

Thank you very much for your help, this does exactly what I need it to do!

[Jokacave]

jiminic

Good. It was my pleasure...