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