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.