Finance

Charts

Statistics

Macros

Search

Vocabulary Collection Setup in Excel VBA

The vocabulary list is located on the second worksheet. The user can view the vocabulary for study purposes and may freely extend, modify, or shorten the list, provided that the structure of the list is maintained.

Structure of the List:

  • The first row contains the headers.
  • The rows below contain the vocabulary entries.
  • The user can control the length of the test by inserting a blank row.
  • During a test, only the vocabulary entries up to the first blank row are included.

In the class module ThisWorkbook, you will find the procedure Workbook_Open():

Private Sub Workbook_Open()
    ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

This procedure ensures that after opening the file, the user always sees the worksheet with the Start button for the vocabulary test, preventing accidental viewing of the vocabulary collection.

0 0 votes
Évaluation de l'article
S’abonner
Notification pour
guest
0 Commentaires
Le plus ancien
Le plus récent Le plus populaire
Online comments
Show all comments
Facebook
Twitter
LinkedIn
WhatsApp
Email
Print
0
We’d love to hear your thoughts — please leave a commentx