I'm using data validation for a list of acceptable answers, would you
recommend the combo box route instead?

"lennyx2" wrote:

Hi to all,
I'm not too good with macros, but i'm learning.
I am constructing a survey tool and would like a macro that automatically
goes to a cell based on the Yes or No response selected from a drop-down box
in another cell. For example, if NO then go to question #4.

Any thoughts? Much appreciated.