Macro - Setence Completion
 

I am trying to do the following.

Sheet 1, each cell in the range B4:B54 will contain one question, thus
altogether I have 50 questions. I would like to create a macro that when I
run it, a message box will appear.

The message box will randomly ask me each question from the range B4:B54
either 12, 16, or 24 times in a row/consecutively before moving to the next
question. I would also like the message box to contain a field big enough
for me to answer the question inside of each time it is asked.

After I type my response and press enter, I would like a new worksheet to be
created. In the new worksheet I would like the question that was asked to go
into C2 and a record of every answer I gave to go into the new worksheet
starting in C4 and going down to C16, C20, or C28 depending on how many times
I answered the question in a row/consecutively whether it was 12, 16, or 24
times. Finally I would like to have a way that I can exit the Macro but not
loose the data that has already been gathered. Is this possible?

Macro - Setence Completion
 

Which part are you having a problem with ?

Tim

"TGalin" wrote in message
...
I am trying to do the following.

Sheet 1, each cell in the range B4:B54 will contain one question, thus
altogether I have 50 questions. I would like to create a macro that when
I
run it, a message box will appear.

The message box will randomly ask me each question from the range B4:B54
either 12, 16, or 24 times in a row/consecutively before moving to the
next
question. I would also like the message box to contain a field big enough
for me to answer the question inside of each time it is asked.

After I type my response and press enter, I would like a new worksheet to
be
created. In the new worksheet I would like the question that was asked to
go
into C2 and a record of every answer I gave to go into the new worksheet
starting in C4 and going down to C16, C20, or C28 depending on how many
times
I answered the question in a row/consecutively whether it was 12, 16, or
24
times. Finally I would like to have a way that I can exit the Macro but
not
loose the data that has already been gathered. Is this possible?

Macro - Setence Completion
 

Is this possible in Excel?

"Tim Williams" wrote:

Which part are you having a problem with ?

Tim

"TGalin" wrote in message
...
I am trying to do the following.

Sheet 1, each cell in the range B4:B54 will contain one question, thus
altogether I have 50 questions. I would like to create a macro that when
I
run it, a message box will appear.

The message box will randomly ask me each question from the range B4:B54
either 12, 16, or 24 times in a row/consecutively before moving to the
next
question. I would also like the message box to contain a field big enough
for me to answer the question inside of each time it is asked.

After I type my response and press enter, I would like a new worksheet to
be
created. In the new worksheet I would like the question that was asked to
go
into C2 and a record of every answer I gave to go into the new worksheet
starting in C4 and going down to C16, C20, or C28 depending on how many
times
I answered the question in a row/consecutively whether it was 12, 16, or
24
times. Finally I would like to have a way that I can exit the Macro but
not
loose the data that has already been gathered. Is this possible?