Skip to content

Latest commit

 

History

History
47 lines (30 loc) · 1.05 KB

Excel.AddIns.Item.md

File metadata and controls

47 lines (30 loc) · 1.05 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
AddIns.Item property (Excel)
vbaxl10.chm187075
vbaxl10.chm187075
Excel.AddIns.Item
417987d5-322c-2784-c51e-18a1fa7578d1
04/03/2019
medium

AddIns.Item property (Excel)

Returns a single object from a collection.

Syntax

expression.Item (Index)

expression A variable that represents an AddIns 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 AddIns method is the Title property of the AddIn object.

If ThisWorkbook.Application.AddIns.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]