ChangedItemIndex

This read-only property returns information about changes within the OnChange event.

To get the index of the changed item , retrieve the ChangeInfo parameter of the OnChange event to check if it is CollItemAdded, CollItemPreRemove, CollItemRemoved, or CollItemRenamed.

If you call this method outside the OnChange event, it returns -1.

Syntax

ChangedItemIndex As Long