Hi all,
I have got an excel file which allows the users to take up objective type questions. A user form is used in this excel. There are 2 sheets. One displays the userform and the other sheets contains the questions and answers and this sheet will be hidden. The macro randomly chooses 10 questions and will display it to the user. The user will be able to view the next question only after he/she completes the first one and click next. After completing all the questions, once you hit next it shows a msg box with your score.
Now the problem is I want this score to be automatically transferred to another excel file with the users ID. And also the user should be able to take up the test only once. I am dont know the code for this. Please help me to solve this.....
Thanks in advance...
I have got an excel file which allows the users to take up objective type questions. A user form is used in this excel. There are 2 sheets. One displays the userform and the other sheets contains the questions and answers and this sheet will be hidden. The macro randomly chooses 10 questions and will display it to the user. The user will be able to view the next question only after he/she completes the first one and click next. After completing all the questions, once you hit next it shows a msg box with your score.
Now the problem is I want this score to be automatically transferred to another excel file with the users ID. And also the user should be able to take up the test only once. I am dont know the code for this. Please help me to solve this.....
Thanks in advance...