Hi all
I have the following code in my workbook that throws up a msgbox when the necessary 'Date' cell is blank:
I've adapted this code from some other code that I've recently written, but this doesn't quite do what I want.Please Login or Register to view this content.
Firstly, is there a way to adapt the code so that, instead of throwing up the 'Yes/No' msg box multiple times for any blank cell it finds in the rnage B20:B26, it just shows one MsgBox that lists all the cells in B20:B25 that are blank?
Secondly, I've put these as instructions "before close". Is there a way to rewrite so that if the user clicks 'No', the workbook does not close? (I've put
but that's more of a placeholder as that doesn't actually work.)Please Login or Register to view this content.
Any help greatly appreciated!
Best
Diane
Bookmarks