Database for flashcard-style learning

Hi All,

I'm building a database for learning purposes. The structure is pretty simple. Column A contains all the questions, and Column B contains all the answers. Example:
Q: What is the capital of Nepal? A: Kathmandu.

I need a solution to display a random question in a message box (or in any other appropriate way, like in a cell of another worksheet), then, after clicking 'OK', display the answer in a new message box (or in any other appropriate way). Any help or pointers would be appreciated. In your response however, please refrain from posting urls, unless it specifically gives a viable solution to the aforementioned problem.

Thanks in advance.

Hi, Welcome to the Forum!

This code will display a random question. You need to put your sheet name where it says "Your Sheet Name".

Please Login or Register  to view this content.

Originally Posted by davegugg

Hi, Welcome to the Forum!

This code will display a random question. You need to put your sheet name where it says "Your Sheet Name".

Thanks very much, davegugg! You're awesome. *solved*

Any idea how to elminate the beeping?

Also, it would be nice to include a "Did you know the answer?" in the answer message box with a "Yes" and "No" button, and summarize the results in the spreadsheet.

Please Login or Register  to view this content.

Do you already have data in cells C1 and D1 of the sheet with the q's and a's? You can change the targets to empty, unused cells.

Something like this:

Please Login or Register  to view this content.

If I use Davegugg's code, then it would be

Please Login or Register  to view this content.

I'd suggest just a few changes from what Whizbang last proposed:

Please Login or Register  to view this content.

By using a do...loop until loop you can cut down on the amount of message boxes. Also, save the final score messagebox for the end of the procedure. Also, I'd combine the answer messagebox with the question of whether you got it right. Lastly, no need to code lines to define the two long variables twice - just define them once inside the loop.

I'd add the header "Questions answered correctly" to Cell A1 on Sheet 2 and "Questions anwered incorrectly" to Cell B1 on Sheet 2. This code should be in its own module.

Please Login or Register  to view this content.

Don't worry about asking too many questions, everyone starts somewhere ; )
Just be sure to look at how the changes in the code affected the final product.