Excel 2007 : Formula Overriding Data Validation

Hello to all of you.
Wasn't sure how to TITLE this Thread / Question.

I'm working on a Worksheet that I have a Data Validation in Cell B3 ( etc through that column ) that gives a Drop Down Menu of Choices...ex. NAMES.

What I need is if cell F3 is not equal to 0.... ( <>0 ) then the "name" listed in cell B3 is then returned to an empty (Blank) value...for lack of better words...

anyways...once info has expired its time...and F3 has been deleted..then the B3 data Validation ( NAME ) is zeroed out...is this possible? I have been trying all kinds of =IF , =if(AND( ...etc...but as soon as I add a formula to a cell that contains the Data Validation...the Data Validation is over-riden

Thank you for your time...

-Martin

You can have a formula and a DV in the same cell, but you have to enter the formula first before applying the DV to the cell. The formula will be able to display anything it's formula calls for, regardless of the DV, but if you USE the drop box option and make a selection, the formula is permanently removed and replaced by your selection.

Thank you very much. I was able to get that to work.

I did need to change the

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Anyway I can make this run automatically without the use of a button?



Oh..and is the .clearContents Range the same value as whats given for Column F?

Thank you very much for your time.

-Martin :-)

I got this to work if this answers one of my questions. From my previous reply

Is this written correctly?

Please Login or Register  to view this content.

This will clear Column B,A & H

Please note I purposly omitted some of the code you supplied...