Hi. I need some advice on this form I am creating.
For instance, In Cell A, there is drop down menu which has the selection "yes" & "no".
Then there's Cell B, C, D, E, F which are in turn refers to the source of the Cell A's data (e.g. Home, School, Office, Cafe, Others).
When the answer in Cell A is "Yes", respondents are then required to select (thru dropdown the "√" symbol) at least 1 or more from B, C, D, E, F. Respondents should make at least 1 selection from B-F if they answer "Yes" to Cell A.
What VB script can I use for this? Would really appreciate this. Thank you very much.
For instance, In Cell A, there is drop down menu which has the selection "yes" & "no".
Then there's Cell B, C, D, E, F which are in turn refers to the source of the Cell A's data (e.g. Home, School, Office, Cafe, Others).
When the answer in Cell A is "Yes", respondents are then required to select (thru dropdown the "√" symbol) at least 1 or more from B, C, D, E, F. Respondents should make at least 1 selection from B-F if they answer "Yes" to Cell A.
- Cell A = Has Internet Connection? Yes/No
- Cell B-F = Where do you connect to the Internet? Choose 1 or more by "√".
What VB script can I use for this? Would really appreciate this. Thank you very much.