A macro that would run automaticaly after picking certain text from drop down menu

Hi everybody,
I've been programing macros only for 10 days and can not solve this problem:

I would like to create macro that would run automatically after selecting "YES" or "NO" in cell A1 from drop down menu .

If "YES" is selected than than the text in cell B2 contains text from cell C2
if "NO" is selected than than the text in cell B2 contains text from cell C3

BUT, if I choose "MAYBE" in the cell A1 I should still be able to use some drop-down menu in cell B2.

I would really appreciate your help because this is above my capacity
Thank you very much

Hi. try below ....

Please Login or Register  to view this content.

thank you, it works but it is very slow