Collections

[mikeosborne]

Can I create a public collection, and how would I go about creating this?

[Ed Jobe]

Declare the variable in the module declaration section.

[mikeosborne]

I don't think I ask the quesiton right, I want to build a collection one time and then that collection in several modules and userforms without have to build the that collection in each place that I want to use it.

[Ed Jobe]

You asked the question right. If you declare a variable at module level, it will have scope to your whole project.