Mandatory fields in Excel

Morning all,

I'm working on an Excel workbook where i'd like to make certain columns mandatory. What i've written so far (see below) asks Excel to look at Cell "B4" and if it equals "Addition" then look at Cell "A4" and if blank - prevent the user from saving.

My questions are as follows:

1) Instead of asking Excel to look at cell "B4" can I ask it to look at a Cell range (E.G. B4:B78) so if any of those cells equal "Addition" it will then look at the A cell in the same row?
2) Can I set Excel to look for "Addition", "Deletion" & "Change" ... I can't seem to figure out how to add three values in and make it work,
3) Third, and last question (promise!!!), is can I make the code do the same for several columns? To elaborate ... If the B column range equals one of the 3 values above then columns "A, C, D and E" must all be filled out before saving the workbook.

Hope this makes sense,
Any help would be greatly appreciated!!

Please Login or Register  to view this content.