JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
im currently trying to learn about VBA arrays so if you know any good learning resources i would appreciate it.
With the following below, how can i store or update the values assigned to an IDNO in an array and make it available to other modules.
So if:
Range("B3") = 7
and
Range("C3") = 2171
this gets stored, or updated if 7 is already in array
then entering 7 in Range("B9") and running the macro should output the stored value for IDNO: 7
Appreciate any help
im currently trying to learn about VBA arrays so if you know any good learning resources i would appreciate it.
With the following below, how can i store or update the values assigned to an IDNO in an array and make it available to other modules.

So if:
Range("B3") = 7
and
Range("C3") = 2171
this gets stored, or updated if 7 is already in array
then entering 7 in Range("B9") and running the macro should output the stored value for IDNO: 7
Appreciate any help