Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quiz test
I want to create an Excel VBA that will be actualy a QUIZ with questions that
every 15 mins will ask me to answer a question that will be placed on a form that will show up on top of my opened applications. (I have to know the answers by heart for a test. probably 200 questions with multiple answers) Does anyone did it before? Any suggestions? I have the questions and the good answers on a Excel Sheet. I was thinking to use them in a loop that automaticaly modify the question and the good answer on a VBA form... Thank you everyone and have a great weekend!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quiz test
Hi Dan
Not clear what you want, but have a look at this site : http://www.accessanalytic.com.au/ser...excel_test.php One question every 15 minutes with 200 question ????? You may need to rethink that. HTH John "Dan Tabla" wrote in message ... I want to create an Excel VBA that will be actualy a QUIZ with questions that every 15 mins will ask me to answer a question that will be placed on a form that will show up on top of my opened applications. (I have to know the answers by heart for a test. probably 200 questions with multiple answers) Does anyone did it before? Any suggestions? I have the questions and the good answers on a Excel Sheet. I was thinking to use them in a loop that automaticaly modify the question and the good answer on a VBA form... Thank you everyone and have a great weekend!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quiz test
Thank you so much for your answer John!
I have 200 lines with 5 columns of data. First column will be the question Second column will be the wright answer. Third, fourth and fifth columns will be wrong answers. I have to build up a software that will choose randomly from the 200 lines and place the question and the possible answers randomly in a form that is having 4 radio buttons to choose the answer from. (the reason of random is not to visualy memorize the questions/answer without thinking) That form will pop up will I'm working at my desk every 15 minutes during my 8 hour schedule and then stop till I'll restarted next morning. I hope this time I m more detailed with what I want to do Have a nice weekend and everyonen compile successfully!!! "John" wrote: Hi Dan Not clear what you want, but have a look at this site : http://www.accessanalytic.com.au/ser...excel_test.php One question every 15 minutes with 200 question ????? You may need to rethink that. HTH John "Dan Tabla" wrote in message ... I want to create an Excel VBA that will be actualy a QUIZ with questions that every 15 mins will ask me to answer a question that will be placed on a form that will show up on top of my opened applications. (I have to know the answers by heart for a test. probably 200 questions with multiple answers) Does anyone did it before? Any suggestions? I have the questions and the good answers on a Excel Sheet. I was thinking to use them in a loop that automaticaly modify the question and the good answer on a VBA form... Thank you everyone and have a great weekend!!! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quiz Sheet | Excel Worksheet Functions | |||
Training -- quiz | Excel Discussion (Misc queries) | |||
Creating a Quiz... | Excel Discussion (Misc queries) | |||
Quiz... | Excel Discussion (Misc queries) | |||
Quiz.xls | Excel Programming |