Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Code
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to dll and vba code trouble shoot. | Excel Programming | |||
Slow code when used as VBA code instead of macro (copying visible columns) | Excel Programming | |||
Can I use code/macro to change code/macro in an existing file? | Excel Programming | |||
read macro code by vb code | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming |