ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Quiz test (https://www.excelbanter.com/excel-programming/443100-quiz-test.html)

Dan Tabla[_2_]

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!!!

John[_22_]

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!!!



Dan Tabla[_2_]

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