Item property
Sets or returns an item for a specified key in a Dictionary object. For collections, returns an item based on the specified key. Read/write.
Syntax
object.Item (key) [ = newitem ]
The Item property has the following parts:
Part | Description |
---|---|
object | Required. Always the name of a Collection or Dictionary object. |
key | Required. Key associated with the item being retrieved or added. |
newitem | Optional. Used for Dictionary object only; no application for collections. If provided, newitem is the new value associated with the specified key. |
Remarks
If key is not found when changing an item, a new key is created with the specified newitem. If key is not found when attempting to return an existing item, a new key is created and its corresponding item is left empty.
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.