Macro Code

[TGalin]

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.

 

[Bob Bridges]

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]

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]

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.