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.

Originally Posted by Bruno Campanini

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

Originally Posted by hussnainh8

Hi,

Thanks for the help... I want Excel to show a error message if cells D9 till D16 are "Empty". A simple error message which says "Please fill empty cell in" would be fine.. I did already state this in my first message.

Thank You.