Developing a Quiz Application using VB and Excel - Unable to halt the loop to enable Input

[bhutaniv]

Hi!
This is the first time that I am actually posting a Thread (after spending a sleepless night trying to debug). Hope I would find a solution here.

I am stuck up in this code.

I am using an excel file with a Question Bank and am displaying the Question in a TextBox on a user form. 4 Possible Answers are displayed using Option Button Captions and am looping thru the same code to display all the questions one by one.

My only problem is that I am unable to make the program wait for user to click on the right option button and submit his reply (command button - with a command_click event captured).

When the question with 4 Options is displayed I want the program to give the user 30 secs (should be displayed in a timer) to click on any of the options and then click on Submit command. The program simply loops thru the code.

Any help would be highly appreciated.

Please Login or Register  to view this content.

[/I]

[naveenmarapaka]

Hello Bhutaniv.... Welcome....

Would Appreciate if you can post your excel data... for better understanding.....


regards

[bhutaniv]

Thanks for the prompt reply. I am enclosing the Excel File. i am referring to User Form - Quiz. In the LoadQuiz module I have disabled loop because it goes into a permanent loop.

Regards
Vineet

[naveenmarapaka]

Hi, I haven't understand your program...
as a far as I understand you basically have 9 questions to ask users right on the userform
which after clicking submit button it will move on to next question right ?

and you are giving total of 30 seconds to answer 9 questions or each questions has 30 secs..
and you already have a predefined questions sheet with answers and if user answer is matched with your sheet you are giving 10 marks for each question right ? and all these info to be added to score sheet..... ?

[bhutaniv]

as a far as I understand you basically have 9 questions to ask users right on the userform
which after clicking submit button it will move on to next question right ? - Yes

and you are giving total of 30 seconds to answer 9 questions or each questions has 30 secs.. - Each Question has 30 secs.

and you already have a predefined questions sheet with answers and if user answer is matched with your sheet you are giving 10 marks for each question right ? and all these info to be added to score sheet..... ? - Yes.

It is programmed that way - but the problem is that I am unable to take user input while the loop is being executed.

[naveenmarapaka]

Hi Just only run userform Initialize ... and check.. might you need to add time value also for iteration of question.

[bhutaniv]

Wow!!! Amazing....Thanks a lot for the help extended. I really appreciate this. :-)

How can I set a timer (30 secs) for each question? is it possible to display the timer on the user form so that the user knows how much time is left for him to answer?

[naveenmarapaka]

Hi.
Pls check now.... logically what I felt, I made... this is what I can help you....