Opv
04-20-2010, 03:03 PM
The attached sheet is a sample of a set of Greek flash cards. In summary, the workbook consists of two sheets, a "database" of terms/phrases and a "practice" sheet which pulls in one word at a time from the database and allows me to practice writing (typing) and saying the Greek term that goes with the English term displayed on the practice sheet. Now for the specific pieces. The functionality incorporated into the workbook consists of the following scripts:
1. A defined Name: =OFFSET(Database!$A$3,1,0,COUNTA(Database!$A:$A)-1,3)
MODULE ONE:
2. A Randomize script which is executed when I click on the appropriate button within the Practice sheet. This script simply randomizes and ranks the index for the database so that the terms can be pulled into the Practice sheet in a different order.
3. A findNext script which tracks how many terms/phrases are remaining to be displayed.
4. A GetNext script which actually cycles through the ordered (ranked) items and pulls in and displays the next appropriate term from the Database.
MODULE TWO:
5. a showGreek script which temporarily displays the Greek term if I determine I need it.
6. a hideGreek script which automatically hids the Greek term after 5 seconds.
PRACTICE SHEET:
7. A Worksheet_Change script which automatically calls the next term/phrase ONLY if I correctly type in the Greek term to go with the English word/phrase displayed.
Below the row on which the practice data is displayed, I have arranged a series of cells to display the descriptors for the term/phrase displayed, i.e., Case, Gender, Number, Tense, Voice, etc. These cells are populated using VLookup.
Now, what I am wanting to do is make all of the above script continue to function as they currently do even if I have the Database in Auto Filter mode. For example, there are occasions where I need to focus on specific words/phrases more so than others. I would like to be able to filter the database so that only the visible words/phrases are displayed. Any help will be greatly appreciated.
Thanks,
Opv
1. A defined Name: =OFFSET(Database!$A$3,1,0,COUNTA(Database!$A:$A)-1,3)
MODULE ONE:
2. A Randomize script which is executed when I click on the appropriate button within the Practice sheet. This script simply randomizes and ranks the index for the database so that the terms can be pulled into the Practice sheet in a different order.
3. A findNext script which tracks how many terms/phrases are remaining to be displayed.
4. A GetNext script which actually cycles through the ordered (ranked) items and pulls in and displays the next appropriate term from the Database.
MODULE TWO:
5. a showGreek script which temporarily displays the Greek term if I determine I need it.
6. a hideGreek script which automatically hids the Greek term after 5 seconds.
PRACTICE SHEET:
7. A Worksheet_Change script which automatically calls the next term/phrase ONLY if I correctly type in the Greek term to go with the English word/phrase displayed.
Below the row on which the practice data is displayed, I have arranged a series of cells to display the descriptors for the term/phrase displayed, i.e., Case, Gender, Number, Tense, Voice, etc. These cells are populated using VLookup.
Now, what I am wanting to do is make all of the above script continue to function as they currently do even if I have the Database in Auto Filter mode. For example, there are occasions where I need to focus on specific words/phrases more so than others. I would like to be able to filter the database so that only the visible words/phrases are displayed. Any help will be greatly appreciated.
Thanks,
Opv