B
Bob
I am creating a Questionnaire with the following columns:
Column A – contains the list of questions.
Column B – contains Data Validation dropdown boxes with “Yes†and “Noâ€
choices.
Column C – used for inputting an Explanation.
For each question, the following business rule must be satisfied before
allowing the user to move to any other question:
If a user responds “Yes†in column B, the active cell automatically becomes
the corresponding cell in column C, and the user MUST provide an explanation
(>=20 characters in length) before being allowed to exit the cell.
Being a VBA novice, I do not have a clue how to program this. Any help
would be greatly appreciated.
Thanks,
Bob
Column A – contains the list of questions.
Column B – contains Data Validation dropdown boxes with “Yes†and “Noâ€
choices.
Column C – used for inputting an Explanation.
For each question, the following business rule must be satisfied before
allowing the user to move to any other question:
If a user responds “Yes†in column B, the active cell automatically becomes
the corresponding cell in column C, and the user MUST provide an explanation
(>=20 characters in length) before being allowed to exit the cell.
Being a VBA novice, I do not have a clue how to program this. Any help
would be greatly appreciated.
Thanks,
Bob