Excel VBA - Mandatory cells cannot stay blank?

[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.

[hussnainh8]

Please can someone shed some light on this!

Thanks.

[thetraininglady]

I'm unsure about VBA coding for this but you could use Data Validation to create this effect. Just thought I'd throw the idea out there.

[hussnainh8]

Originally Posted by thetraininglady

I'm unsure about VBA coding for this but you could use Data Validation to create this effect. Just thought I'd throw the idea out there.

Ahh even better as it is easier for me to do it! (Not very experienced with coding, I just thought it would be easier) .. Could you tell me what rule I would use for this or could you do it for me and send me the attachment again?

Thank you for your reply.

[thetraininglady]

I am home with a sick child today so i just googled and found this article on Data Validation which might assist. http://office.microsoft.com/en-au/ex...600.aspx#BM4_2
Take a look at the info on "Restrict data entry to a whole number within limits".

If you are still stuck I can try to take a closer look at this over the weekend and possibly put something together for you.

[hussnainh8]

Originally Posted by thetraininglady

I am home with a sick child today so i just googled and found this article on Data Validation which might assist. http://office.microsoft.com/en-au/ex...600.aspx#BM4_2
Take a look at the info on "Restrict data entry to a whole number within limits".

If you are still stuck I can try to take a closer look at this over the weekend and possibly put something together for you.

Hi,

Sorry to hear about your child, hope they get better.. I have tried data validation and still cannot seem to get it working, I dont know if I am missing something out or what but it just will not work Please go through the excel file I attached and do it for me whenever you are free, will be much appreciated.

[Bruno Campanini]

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

[hussnainh8]

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

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.

[Pecoflyer]

Hi guys
no mod being around, it would be nice if you didn't quote whole posts unnecessarily. They are just clutter and make the thread very long. Thx

[Bruno Campanini]

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.

Sorry, we are speaking two different languages.

Bruno