Message box to return values in cells

[Godders199]

Hello, i have been looking for an example of VBA for a message box which returns values of cells where criteria is met. While i have found VBA which will return the cell range, i cannot find an example of displaying values.

here is an example of what i mean.

order	Name	Date
1	Pete
2	bill	13/11/2017
3	james
4	jim	13/11/2017

<tbody>
</tbody><colgroup><col><col><col></colgroup>

From the above table, I would require a message box to display the order number and name if the date is blank.

If anyone has an example of this VBA it would be appreciated.

Thanks

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

My Aswer is this - Thank you