Collection

Collection

DESCRIPTION:

VBA Collection is a simple native data structure available in VBA to store (collect as you wish) objects. VBA Collections are more flexible than VBA Arrays as they are not limited in their size at any point in time and don’t require manual re-sizing. Collections are also useful when you don’t want to leverage there more complex (but quite similar) Data Structures like the VBA ArrayList or even a VBA Dictionary. There are 2 ways to initiate collection:

1. SET NEW and

2. DIM NEW

 

Collection with SET NEW

 

Collection with DIM NEW

 

 

Ratings: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...