Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. . |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
New Excel user needs help with simple Macro... | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |