Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create a static Collection (lookup table object)

Status
Not open for further replies.

djmc

Programmer
Jun 12, 2002
179
CA
Hello,

I understand you can create something similar to a hashtable in VBA called a Collection and that you can use the add function to add key,value pairs.

I was wondering if there is a way to create a static Collection object without using the add function. Like
myCollection = {"a:1","b:2"} or whatever.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top