language test

Hi all,

I'd like to make a language test (Latin) in Excel for my kids.
I'd like to get a number of random words (let's say 10) out of a defined list where they'd need to give all the necessary information they need to study (translation off course, but maybe also other info)
When they filled in all the info, they should be able to end the exercise (via a button) and then get there results AND the correction if any...


As I never really did programming in VBA, I don't really know where to start.


Can anybody help me?

Thanks in advance,

Bram

Dear Ali,

Thanks for you quick reply.
Maybe I didn't phrase the objective clearly enough. What I'm trying to make, is a test, where they'd get 10 words in Latin (out of the ~250 they need to know this year) and they'd need to give the translation (as defined in there books)
So not translations of texts, no subtleties, no discussions :-)


Kind regards,


Bram

Dear Ali,

Here's how the worksheet would look like. The list of words isn't complete yet, but it will be updated after every lesson.


Kind regards,

Bram

It should indeed be with articles and correct dutch spelling, as that's how they have to do it on there tests as well.

whoops
I'll make sure they won't read this..

Just to make sure we are on the right track

Userform will randomly load 10 latin words (just to give you an idea the second row of textboxes are the translations) - when the third row is filled and submitted, if they equal the second row then all good otherwise they will be marked red.

The second row can be hidden see Initialize module

See attached

Hi all,

thanks everybody for your help!
I made some changes (to allow for more things to be filled in as necessary for their tests at school).

This is more then sufficient for me, so I'll stick with this.


See you around.

Bram