How to use VBA to create two warning messages related to one cell

[Ledmac]

The Column C is a drop down list. The Column E is VLOOKUP function (Look up Column C and return certain values). Column F is manual update column. I would like to create two warning messages:
1) If Column C is blank, a warning message "Fill Column C" shows up when trying to enter numbers in Column F.
2) If "Wrong" shows up in Column E as a result of the VLOOKUP, a warning message "Correct Column E" shows up when try to enter numbers in Column F.

So, to enter any numbers under Column F, Column C needs to be selected and Column E has to be valid (cannot be "Wrong").

I would think this requires VBA codes (preferred), as I don't know how to have two different conditions on the same cell by Data Validation.

Much appreciate your help in advance!

[ajryan88]

Hi.

Try this code in the worksheet's module (right-click on the worksheet tab and select "View Code"):

Please Login or Register  to view this content.

Hope this helps

[Ledmac]

It works! Thank you!

Can we add a condition that only Row 11 to 25 applies? Right now the whole Column F applies...

[ajryan88]

Sure! Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hope this helps