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.

[TABLE="width: 331"]
<tbody>[TR]
[TD]order[/TD]
[TD]Name[/TD]
[TD]Date[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Pete[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]bill[/TD]
[TD]13/11/2017[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]james[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]jim [/TD]
[TD]13/11/2017[/TD]
[/TR]
</tbody><colgroup><col><col><col></colgroup>[/TABLE]

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