Skip to content

Latest commit

 

History

History
47 lines (30 loc) · 1.06 KB

Excel.AddIns2.Item.md

File metadata and controls

47 lines (30 loc) · 1.06 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
AddIns2.Item property (Excel)
vbaxl10.chm867075
vbaxl10.chm867075
Excel.AddIns2.Item
6a0ee1ca-75ba-14ed-1bbb-606480aeafbe
04/03/2019
medium

AddIns2.Item property (Excel)

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that returns an AddIns2 object.

Parameters

Name Required/Optional Data type Description
Index Required Variant The name or index number of the object.

Example

This example displays the status of the Analysis ToolPak add-in. Note that the string used as the index to the AddIns2 method is the Title property of the AddIn object.

If ThisWorkbook.Application.AddIns2.Item("Analysis ToolPak").Installed = True Then 
 MsgBox "Analysis ToolPak add-in is installed" 
Else 
 MsgBox "Analysis ToolPak add-in is not installed" 
End If

[!includeSupport and feedback]