Table of contents
Collapse the table of content
Expand the table of content

Count Property (Visual Basic for Applications)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns a Long (long integer) containing the number of objects in acollection. Read-only.


This example uses the Collection object's Count property to specify how many iterations are required to remove all the elements of the collection called MyClasses. When collections are numerically indexed, the base is 1 by default. Since collections are reindexed automatically when a removal is made, the following code removes the first member on each iteration.

Dim Num, MyClasses
For Num = 1 To MyClasses. Count    ' Remove name from the collection.
    MyClasses.Remove 1    ' Default collection numeric indexes
Next    ' begin at 1.
© 2018 Microsoft