azizrasul
Well-known Member
- Joined
- Jul 7, 2003
- Messages
- 1,304
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
I have
at the top of a module so that it can be used by multiple functions. How do I enable the values in MyDict to remain in memory when I use
so that I can use the values in MyDict in separate functions within the same module?
As an aside, how do you declare variables so that the value of the variable can be retrieved later when a function that uses the variable has finished and another function wants to use the value held in that variable?
Code:
Dim MyDict As Dictionaryat the top of a module so that it can be used by multiple functions. How do I enable the values in MyDict to remain in memory when I use
Code:
MyDict.Add appAccess.currentproject.Name, appAccessso that I can use the values in MyDict in separate functions within the same module?
As an aside, how do you declare variables so that the value of the variable can be retrieved later when a function that uses the variable has finished and another function wants to use the value held in that variable?
Last edited:
