help with for loops; wait for user input

I'm trying to create a test engine that will load questions randomly for the question bank.

Say I have 3 sheets

1. Form Sheet = Where I have all of my form
2. Question Sheet = Where I have all of my questions
3. Order Sheet = Where I want to rearrange the questions randomly.

I use vlookup for this function

Say A1 is where I need to key in the question number so b1 will look it up on the table based on the value on A1 (Say 1 to 15)

Now, I have it arranged at random in "order sheet"

I just want to load the question number from 1 t 15 from the "Order Sheet" The problem that I have is the user needs to enter his answer before proceeding to the next question.


I don't have the file with me because I cannot transfer it from my work computer.

Here is my analogy

Step 1: Arrange number
Step 2: Load the first question
Step 3: By clicking next, check if the answer is correct add 1 to the score if correct.
Step 4: Load the next question
Step 5: Enter answer and hit next
Step 6: Load the next question until the user answer all of the questions.

Please Login or Register  to view this content.

I hope someone could help me or if you have a better approach with this, please suggest.

Thank you so much Andy. I'll try this code. Looks good.

Please Login or Register  to view this content.

everything is great. I had a problem generating question then I suddenly noticed that you've referenced a wrong sheet. Thank you so much again. I need to custom fit this to my project.