macro that brings user to cell based on "yes/no" response

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.

hi,
assuming that each question has a combo box.
Assuming that the combo box in column A
Assuming that each question is on each row.
Right click the combo box in design mode. cleck view code.
Private Sub ComboBox1_Change()
If ComboBox1.Value = "No" Then
Range("B5").select
end if
end sub
>-----Original Message-----
>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.
>.
>

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.