Hi everyone,

I would like to introduce the following automation to my userform. If the user chooses two consecutive times Option B (only for B), I would like the program to autofill B looping through the particular question, and jump to the next Question.


Question SubQuestion Choice
1..................1................A
1..................2................A
1..................3................A
1..................4................B
1..................5................B
1..................6................Autofill
1..................7................Autofill
2..................1................User restarts here (and here the same, if there are two consecutive B options, program jumps to the next Question).
2..................2
2..................3
2..................4
2..................5
3..................1
3..................2
3..................3
3..................4
3..................5

The code I am using is the following:

Please Login or Register  to view this content.
Please, let me know if my autofill option is correctly states. It means that the proceudre copies "B" and pastes it in the destination Until Question changes?

I am having issues with the loop though condition - until the question Changes or Ends.

Moreover, do I have to have these conditions in a procedure such as:

Please Login or Register  to view this content.
Thanks a lot in advance, your help is much appreciated.
Anisa