VBA to automatically return a value when codition is met.

[spittingfire]

Hi All,

I have the below simple VBA script that works well on it's own

Please Login or Register  to view this content.

However what I want to do is to have it execute automatically the value of "000-0000-0000" when F3 is "NO"

I tried changing the VBA to

Please Login or Register  to view this content.

and putting it into the sheet name but it just causes excel to crash and close.

So clearly I am doing something wrong and need some help fixing it.

Thanks in advance for any help you can provide.

[sourabhg98]

It works fine for me.
However, I feel that as your code runs each time when any value on the sheet changes, it might be leading to the crash. But I am not sure at all.
You can try limiting the range to just "F3" as follows-

Please Login or Register  to view this content.

[spittingfire]

Thanks such much sourabhg98. Finally it runs without crashing my Excel. Much appreciated for the help and the explanation as well.

[sourabhg98]

Glad to know that helped!!
Thanks for the feedback and reputation!

Have a Great Day!