-
Refer to Excel collections in VBA with a "variable" name?
Hi there,
In the code I'm working on, I would like to (if possible) set up collections and refer to them with names that are not "hard-coded" but are generated in the code. Is this possible?
e.g. I have a collection with bank account data in objects. I have 3 bank accounts currently, so have created 3 objects (colKeyWordsBank1List, colKeyWordsBank2List, colKeyWordsBank3List). What I would like to do is have the objects created and referred to with something like "colKeyWordsBank" & i & "List" where i is variable.
I've tried to google a solution with no luck. Maybe someone in this forum can point me to a solution? (or confirm if it is at all possible).
I'm running Excel 365 on Win11 and Mac.
Thanks in advance for any feedback ...
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules