Cells are blank, message box on close

If all these cells are empty, then a message box pops up on close saying some are empty.

I know how to do the message box, I'm not sure how to write it so that:
if D3, D4, D8, D9, D10, D12, D13, etc. etc. are blank, then pop upmsg box

All of the cells in column D that I'm concerned with are unlocked. So we could say something like if any unlocked cells in column d are blank, then message box.

Thanks!

JBeaucaire is probably more on track to what you want to do but just in case you want a look at the before_close event something like this might work.

Please Login or Register  to view this content.

Note: A loop is not the best way to go here and there could be many issues depending on whats going on in the other cells of column D.