option button exercise 25122012.xlsm
I am preparing a utility for answering multiple choice questions using option buttons. After 1st question is answered, a command button will be pressed for next question to be displayed and so on. At the end of the exercise correct answers to be counted and displayed, correct answers to be shown for the wrongly answered questions.

I am having the data in more than 100 rows/5 columns in one worksheet2. I want to display the data in worksheet1 row by row upon pressing command button. Like "next record" command in database programs (VB etc).

The sample file is attached.

Thank You in anticipation.