Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q&A Macro
Is a macro capable of doing these things?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q&A Macro
Yes, a macro can be written to do this. It doesn't even sound very
complicated, actually. Let me rephrase to be sure I understand it correctly: You have a spreadsheet that starts with one worksheet, which has a list of questions on it. Your macro is to run down the list and do the following for each question: 1) Create a new worksheet for that question, and copy the question to that worksheet. 2) Select the number 12, 16 or 24. 3) That many times, pose the question to the user and get his answer. Write each answer on the worksheet that was created for that question. At any point, the user should be able to hit a button that causes the logic to stop at that point, without losing any of the data entered so far, and when restarted later to take up the process at that point. Yes, this isn't too hard. Do you need hints on how to write it? How much VBA do you know already? --- "TGalin" wrote: Is a macro capable of doing these things? 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q&A Macro
Yes, you hit the nail on the head. The only thing I would add is that the
questions from the list I also want them to be asked randomly. Sometimes the 10th question will be asked 1st or the 2nd question 5th and so on. I am glad to here its not that hard, I thought it might be complicated. Yes i need lots of hints on how to write it. I don't know that much VBA. On a side note, do you have any recommendations of how I could become more fluent in VBA? Perhaps you know of websites, software, books or other training tools yourself or others have used that have proven to be effective and efficient for those aiming to become more fluent with VBA? "Bob Bridges" wrote: Yes, a macro can be written to do this. It doesn't even sound very complicated, actually. Let me rephrase to be sure I understand it correctly: You have a spreadsheet that starts with one worksheet, which has a list of questions on it. Your macro is to run down the list and do the following for each question: 1) Create a new worksheet for that question, and copy the question to that worksheet. 2) Select the number 12, 16 or 24. 3) That many times, pose the question to the user and get his answer. Write each answer on the worksheet that was created for that question. At any point, the user should be able to hit a button that causes the logic to stop at that point, without losing any of the data entered so far, and when restarted later to take up the process at that point. Yes, this isn't too hard. Do you need hints on how to write it? How much VBA do you know already? --- "TGalin" wrote: Is a macro capable of doing these things? 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q&A Macro
I can walk you through the program a bit at a time - I'm a teacher
at heart, and don't mind taking the time to get you up to speed - but I suggest we switch to email to do it. You can write me at the email address attached to my profile. Just click on my name at the head of this post (where it says "By: Bob Bridges"); then find my email address at the top, modify it as directed (it's not EXACTLY my email address, because of spammers) and send me a note. We'll get started from there. "Not much VBA" isn't a problem, but what about other languages? I mean, am I starting you on programming from the very beginning, or have you coded in other languages and just need to apply the same basic principles to VBA? How fast we go will depend on your experience; if you're an experienced PL/1 or REXX coder, for example, we'll move into VBA in a different way and at a different speed than if you've written in Java, or not at all. --- "TGalin" wrote: Yes, you hit the nail on the head. The only thing I would add is that the questions from the list I also want them to be asked randomly. Sometimes the 10th question will be asked 1st or the 2nd question 5th and so on. I am glad to here its not that hard, I thought it might be complicated. Yes i need lots of hints on how to write it. I don't know that much VBA. On a side note, do you have any recommendations of how I could become more fluent in VBA? Perhaps you know of websites, software, books or other training tools yourself or others have used that have proven to be effective and efficient for those aiming to become more fluent with VBA? --- "Bob Bridges" wrote: Yes, a macro can be written to do this. It doesn't even sound very complicated, actually. Let me rephrase to be sure I understand it correctly: You have a spreadsheet that starts with one worksheet, which has a list of questions on it. Your macro is to run down the list and do the following for each question: 1) Create a new worksheet for that question, and copy the question to that worksheet. 2) Select the number 12, 16 or 24. 3) That many times, pose the question to the user and get his answer. Write each answer on the worksheet that was created for that question. At any point, the user should be able to hit a button that causes the logic to stop at that point, without losing any of the data entered so far, and when restarted later to take up the process at that point. Yes, this isn't too hard. Do you need hints on how to write it? How much VBA do you know already? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q&A Macro
Thank you, that is very kind of you.
"Bob Bridges" wrote: I can walk you through the program a bit at a time - I'm a teacher at heart, and don't mind taking the time to get you up to speed - but I suggest we switch to email to do it. You can write me at the email address attached to my profile. Just click on my name at the head of this post (where it says "By: Bob Bridges"); then find my email address at the top, modify it as directed (it's not EXACTLY my email address, because of spammers) and send me a note. We'll get started from there. "Not much VBA" isn't a problem, but what about other languages? I mean, am I starting you on programming from the very beginning, or have you coded in other languages and just need to apply the same basic principles to VBA? How fast we go will depend on your experience; if you're an experienced PL/1 or REXX coder, for example, we'll move into VBA in a different way and at a different speed than if you've written in Java, or not at all. --- "TGalin" wrote: Yes, you hit the nail on the head. The only thing I would add is that the questions from the list I also want them to be asked randomly. Sometimes the 10th question will be asked 1st or the 2nd question 5th and so on. I am glad to here its not that hard, I thought it might be complicated. Yes i need lots of hints on how to write it. I don't know that much VBA. On a side note, do you have any recommendations of how I could become more fluent in VBA? Perhaps you know of websites, software, books or other training tools yourself or others have used that have proven to be effective and efficient for those aiming to become more fluent with VBA? --- "Bob Bridges" wrote: Yes, a macro can be written to do this. It doesn't even sound very complicated, actually. Let me rephrase to be sure I understand it correctly: You have a spreadsheet that starts with one worksheet, which has a list of questions on it. Your macro is to run down the list and do the following for each question: 1) Create a new worksheet for that question, and copy the question to that worksheet. 2) Select the number 12, 16 or 24. 3) That many times, pose the question to the user and get his answer. Write each answer on the worksheet that was created for that question. At any point, the user should be able to hit a button that causes the logic to stop at that point, without losing any of the data entered so far, and when restarted later to take up the process at that point. Yes, this isn't too hard. Do you need hints on how to write it? How much VBA do you know already? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |