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

L

lennyx2

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.
 
G

Guest

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
 
L

lennyx2

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