Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write to Module While Macro is Running
I have a macro that allows the user to study vocabulary words. At the
outset the array is filled with integers, one for each word. A number is randomly selected from the array and the word corresponding to that number is examined. That number is then removed from the array. Only after all words have been examined is the array is repopulated with all of the numbers. This allows to the user to examine all words before a specific word is encountered again. On exiting the workbook, whatever numbers remain in the array are written to a worksheet, so that the array can be filled with only these remaining numbers the next time the user opens the workbook. This way the user can resume where he or she left off last time. My question, rather than writing the current array to a worksheet, is there a way to write the actual array components (remaining integers) to the module? Everything works fine as is, I'm just wondering if this can be done and eliminate the need for the worksheet to store the array components on exit...TIA, Ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running a module from within a UserForm | Excel Programming | |||
2 Macros running on same module | Excel Worksheet Functions | |||
Running Excel module within Access | Excel Programming | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Write VBA code into a sheet module using VBA | Excel Programming |