I have a workbook with one worksheet. The worksheet has a list of 50
questions ranging from B4:B54. I really need a code that will select each
question randomly, arbitrarily choose 12, 16, or 24, and take these steps
below while asking each question that many times (12, 16, or 24).

1) Open a message box with the question and a field for an answer. After
the user gives an answer and presses enter€¦..

2) A new worksheet get created for that question, and a copy of the question
is pasted into C2 of that new worksheet along with each answer that was given
for the question that was asked. (The macro does not jump to the new
worksheets that are created but it keeps a record of everything that is asked
and answered so when the macro is finished all questions and answers can be
reviewed.

3) At any point, the user is able to hit esc or some other keyboard command
so that the macro stops at that point, without losing any of the data
entered so far, and when restarted later the macro can resume the process
from where it left off.