Create Vocabulary trainer in Excel VBA yourself

Vocabulary trainer. Learn foreign languages. Excel VBA

This program is an Excel file programmed in VBA. With the file the beginners can build up excellent basic vocabulary of any foreign language and the returnees get an optimal refresher of the already learned vocabulary. The program has space for 1000 topics and each topic can have up to 1000 questions.

The excel file has only 1 worksheet "Mask".

In the program everything is done from an input mask. The input mask is activated in the "Mask" worksheet with the "Mask" button.

In the input mask there are 2 yellow buttons: " Create and compose exercise topics" and " To practice".

With the button " Create and compose exercise topics " the frame of the same name is opened.

The frame consists of: Button "X", " Create/Edit topics" Frame, " Create/Edit questions" Frame and a ListBox.

Button "X" closes the frame.

In the frame " Create/Edit topics" there are 2 yellow combo boxes: " ID No.” and " Topic name", 3 TextBoxes: " Designation", "Language 1" and "Language 2", 3 buttons: "Create", "Delete topic" and " Delete everything".
In yellow combo boxes are ID No and topic names of already created topics. If one of the two is clicked, ListBox has yellow background color, has 4 columns, and displays subject database.

In 3 text boxes: Designation, Language 1 and Language 2 will be entered, the entry will be added to the new topic or topic.
With the button "Create" content of the 3 TextBoxes in Topic database is transferred. When a new topic is created, the button has the label "Create" when the theme is changed, the button has the label "To change".

The " Delete topic" button deletes selected topics. Delete password is the number 3.

The “Delete everything” button deletes all topics. Delete password is the number 3.

In the frame "Create/edit questions" there are two yellow combo boxes: " ID No.” and "Topic name", a green combo box "Question number", two text boxes: "Language 1" and "Language 2", three buttons: " Enter" , "Change language" and "Delete question".

In yellow combo boxes are ID No and topic names of already created topics. If one of the two is clicked, ListBox has yellow background color, has 4 columns, and displays subject database.

Green combobox is unlocked when a topic is selected. In green combo box are created questions of selected topic. When clicked, ListBox has green background color, has 3 columns and displays all the questions of the selected topic

In 2 text boxes: Question and translation will be entered, the entry will be added to the selected topic as a new question or as a modified question.
The " Enter" button transfers the content of the 2 TextBoxes into the topic database.

The „Change language“ button changes the order of the languages.

With the button "Delete question" selected question is deleted in selected topic. Delete password is the number 3.

By double-clicking in the ListBox, the number of selected topics is entered in the combo box "ID No." or the question number in the combo box "Question number". In the ListBox, the column widths adapt automatically to column widths of the worksheet shown.

The " To practice" button opens the frame of the same name.

In the just opened frame, only three controls are ready for use: Button "X", combo box "ID No.", Combo box " Topic name". All other controls are empty, or locked, or hidden.

Button "X" closes the frame.

If topic is selected Combobox " Question number" is unlocked and button "Start query" is visible.

“Start query” button starts polling the selected topic. The queries are always stored and begin with the question, which was the next when saving.
In the large white box on the left is always the question, in large white box on the right, the answer is entered and transferred with the "OK" button in the list. If answer was correct, the list will say "OK" in success, if answer was wrong, will be "NOT CORRECT".

In the white box "Number of answers" and in the green combo box there are always number of answered questions, in the field " Number of correct" is the number of correctly answered questions, in the field "Number of wrong" is number of questions answered wrongly, in the field "Selected" there is number the question, which is selected by double-clicking the left mouse button in the list box and is currently being answered.

With the button "OK" the question will be answered, with the button "Back" a question will be jumped back, with the button " Start again" all values will be set to zero and the query will be started again, with the button "Change language" the sequence of languages will be changed.

By double-clicking in the ListBox, the number of selected topics is entered in the combo box "ID No." or the question number is entered in the combo box "Question Number" or the question number is entered in the "Selected" field. In the ListBox, the column widths adapt automatically to column widths of the worksheet shown.