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.

Did you change your mind about having me walk you through the code, TGalin?
or did you just lose track of my first response?

--- "TGalin" wrote:
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.

Not exactly, I just figured it might take you a long time to walk me through
the code, since I don't have much programming experience and I didn't want to
waste your time. Are you a VBA tutor?

"Bob Bridges" wrote:

Did you change your mind about having me walk you through the code, TGalin?
or did you just lose track of my first response?

--- "TGalin" wrote:
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.

Ah. Well, it will take a long time - not weeks or months, but
certainly days - but I think you'll find it's worth the effort. You
have to want to.

And I am a tutor, among other things. Mostly I'm paid for my
experience in data security and automation, but deep down
I'm a teacher and off and on have taught classes and tutored
coworkers either on the job or in my spare time just because
I like to. So by all means feel free to decide it's too much
effort for you to try it, if you want to do that. But don't worry
about my time; if I get tired of you, I'll just say so.

For that matter, you can go ahead and give it a try, and if you
get tired of ME, or of the effort, you can just say so too. You
don't have to finish what you started, if you decide it was a
bad idea.

What we'll do, if you decide to try, is start with a simple part
of your program, and then one at a time add on other pieces.
Offhand this looks like four or five pieces, and each one will
probably take two or four back-and-forths while you test it
and ask questions. But I'm just guessing.

--- "TGalin" wrote:
Not exactly, I just figured it might take you a long time to walk
me through the code, since I don't have much programming
experience and I didn't want to waste your time. Are you a
VBA tutor?

--- "Bob Bridges" wrote:
Did you change your mind about having me walk you through
the code, TGalin? or did you just lose track of my first response?

--- "TGalin" wrote:
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.