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.