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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I'm using data validation for a list of acceptable answers, would you
recommend the combo box route instead?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting cell contents into a macro 1
adding up yes, no, n/a responses 2
macro with input msg based on cell contents 2
Autowrap in a cell 7
Write a macro that hides rows based on empty cells 3
Writing a macro to hide columns based on cell value 2
Apply format to row if yes response 2
macro to ask yes/no question and continue based on answer 5

Back
Top