German vocabulary builder (VBA)

One of the difficult things about learning a new language is the number of new words one has to learn from scratch. You might have tackled the grammar and the syntax principles, but without a big vocabulary, you’ll only be ‘oh how cute, you speak a little X’. And that’s frustrating as hell.

Example for windshield

So I’ve coded this little VBA program that attempts to use the power of spaced repetition to increase the brain’s ability to grab onto new words and solidify recent ones.

The code isn’t that elegant, but it does the trick. Also, I was just learning to use VBA with this program.

So, the user is supposed to add words and for each one add audio and images. The code doesn’t do this for the user, which means that the user should add the words in excel and media in a specific folder.

The spaced repetition part of the code was kinda simple. What was hard was playing audio and ensuring the code was robust enough to deal with data input errors.