Adding data to a msg box

[benno87]

Hi,

I'm trying to add data to a msg box that falls within a certain criteria. If the number of network days (week days) is >= 10, then I want some adjacent text to appear in a msg box, next to the amount of days.

Please find attached a demo excel sheet. Sheet2 is basically what I want to come out onto the msg box because those places have an arrival date greater than 10 days.

Basically I need to group these, then when the code gets to the msg box, this group of data appears on it.

I hope I made myself understandable. Let me know if you need further clarification.

Cheers,

Benno

[protonLeah]

How about:

Please Login or Register  to view this content.

[benno87]

Hi,

Thanks for this. It is almost what I'm after.

At the moment, this returns the number of characters in the names of the countries, that have a arrival time of over 10 days. I want this to return the number of days that are 10.

Eg. if the arrival time is 12 days, i want to return 12 on the msg box.

Your help is greatly appreciated.

Benno

[protonLeah]

Sorry, the msgbox string code should have been:

Please Login or Register  to view this content.

The other code was there because I was trying to line the data in columns, but it didn't work.