Hello
I have table with questions and multi answers with result counter for each question
table.png
and I have quiz userform
userform.png
I want when user open userform, lable1.caption get random question from table
then system make random choose between two variables correct-incorrect
if system choose correct, then lable2.caption get any correct answer for lable1 question
if system choose incorrect, then get any other answers from another questions - so it will be wrong answer -
user have two buttons, if he's choose is correct, add +1 in correct in table for answered question ( and same if incorrect )
then again change the question and start again
if user answer was incorrect, then show him the correct answer in lable3, before system go for next question
and lets system not duplicate the questions in one shoot ( mean if user continue answering without close userform )
note : some question have one or two answers and other answers is blank, so try to not get the blank one
hopefully I can get help
Thanks
Bookmarks