Excel VBA

Bruno Campanini · #7 12-26-2014, 06:46 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Subtotal(103, ) formula and blank cells	zhl203	Excel	1	07-30-2014 03:40 PM
embed excel cells in Word, format won't stay	bsapaka	Word	1	01-26-2014 01:12 AM
Join cells together separated by ; when some are blank	leemoreau	Excel	3	11-03-2013 11:22 AM
www....com does not stay active in excel 2010	waltdisneypixar	Excel	6	06-11-2012 12:55 AM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM