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.