I'm currently working on a quiz style program.
I have an excel sreadsheet with the first column displaying 30 questions and the second column displaying the corresponding correct answers.
I have a visual basic form with a textbox, in here, i would like a random question from my excel (preferably with a code that does not allow the same question to be randomly selected more than once).
The system then needs to work out a score for the the amount of correct answers. If possible, this should be more heavily weighted on the 3 most recent questions answered.
Please could you help me with all or some of this,
thanks
