If then

[trebor1956]

Hi,

I have col A with dropdown list (Pass or Fail) and col B with dropdown list (Y or N). If A2 has Fail and B2 has Y then I would like A2 entry changed to Pass. I seem to be going round in circles, hope you can help.

Thank you.

 

[trebor1956]

I've now put it into the code for the worksheet and it works, many thanks.

 

[jmacleary]

Hi Trebor. Just my two pennyworth - the code needs to go in the worksheet code area. Richt-click on the worksheet name and select View Code, then paste the code in there (and delete it from the workbook section).

 

[trebor1956]

Thanks, done that and it works fine.

many thanks to all who have helped.

 

[6StringJazzer]

That's odd. I put my code in a file and the Sub is never invoked when I select a Y or N from a data validation dropdown list.

That's really odd. I created a file to demonstrate how it doesn't work, and it worked.
Solution implemented as described by OP

 

[Fluff]

I created a file to demonstrate how it doesn't work, and it worked.

? don't you just love it when that happens.