Quote:
Originally Posted by hussnainh8
Hi,
So I have tried my best to use VBA to write a code which shows a message when cells D9 to D16 cannot stay empty. This is for the sheet "order processing screen" How can I do this? I tried my best but cannot seem to get it working. Any help? I have attached the workbook with this thread if anyone wants to open it up and write the code for me, feel free to do that as it has given me a headache now.. The password for the Excel workbook is "hussnain" no capitals etc. You have to unprotect the work sheet to make changes to it. Please help anyone!! 
Thank you. |
The small routine I added (Private Sub Workbook_SheetChange())
works that way:
every time you change a value in a A:J range of the sheet, the code
checks the D cell for zero value and sends a message.
It's not practical: may be you want D cell to be checked after completion
of A:C range, or something like that.
You didn't give enough info...
Bruno