VBA Code: Pop-Up Message Box

[sealion1]

Hi all,

I have a dashboard where I am pulling data that relates to specific key words. Please see attached file.

I would like to have a pop up message that appears on my "dashboard" when I have run the macro saying how many commercial shipments were found.

Does anyone know how to do this?

Thanks.

 

[Deepak]

Didn't find a matching string "commercial shipments" in your xl.

 

[sealion1]

Hi Deepak,

The string for commercial shipments is under "detailed address" in the excel file.

Any help is really appreciated.

Thanks.

 

[Nebu]

Hope this is what you are looking for ...

 

[sealion1]

This works brilliantly - thanks Nebu!