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!!! |
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!!! |
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!!! . |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com