Item method (VBA Add-In Object Model)
Returns the indexed member of a collection.
Syntax
object.Item (index)
The Item method syntax has these parts:
| Part | Description |
|---|---|
| object | Required. An object expression that evaluates to an object in the Applies To list. |
| index | Required. An expression that specifies the position of a member of the collection. If a numeric expression, index must be a number from 1 to the value of the collection's Count property. If a string expression, index must correspond to the key argument specified when the member was added to the collection. |
The following table lists the collections and their corresponding key arguments for use with the Item method. The string that you pass to the Item method must match the collection's key argument.
| Collection | Key argument |
|---|---|
| Windows | Caption property setting |
| LinkedWindows | Caption property setting |
| CodePanes | No unique string is associated with this collection. |
| VBProjects | Name property setting |
| VBComponents | Name property setting |
| References | Name property setting |
| Properties | Name property setting |
Remarks
The index argument can be a numeric value or a string containing the title of the object.
Important
Objects, properties, and methods for controlling linked windows, linked window frames, and docked windows are included on the Macintosh for compatibility with code written in Windows. However, these language elements will generate run-time errors when run on the Macintosh.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.