Vba com add ins developer tab in Excel

Add Ins are built in programs that provide additional features to the users of Excel.

There are a number of Add Ins available for every application of MS Office.

Add Ins, by default, are not readily available, though some important Add-Ins are made available like Team foundation.

The COM Add-Ins facilitate the developer to add new features to the Excel for performing some custom tasks.

The COM is a piece of executable code that is packaged as an Add-In, which is to be installed in the Excel.

When installed, a registry is stored in the machine.

Each COM Add-In is independent, which means, an Add-In installed in Excel cannot be accessed in MS Word.

The COM Add-In is available in the Developer Tab of Excel, as shown below.

excel vba com add ins developer tab

When the button is clicked, the following window opens.

excel vba com add ins developer tab

Note that, there are two add-ins readily available in Excel, with the exception of the last one, "Visual Studio Tools" which was added by me.

This will vary from machine to machine.

To add new Add_Ins, click on the "Add" button, which opens a dialog box listing available Add-Ins in the default OS drive.

In case, there is a Custom Add-In created in any other drive/folder, the same can also be accessed through this dialog box.

excel vba com add ins developer tab


You can find similar Excel Questions and Answer hereunder

1) How can I add a Prefix to a set of numbers in a range?

2) What is the view code button in the Excel Developer Tab

3) How can I dynamically add a hyperlink using VBA?

4) What is the use relative references in the Excel Developer Tab

5) How can I add a 3 Month Moving average Trend line to my line chart?

6) What is the design mode in the developer Tab in Excel

7) How to enable or disable macros execution or loading in Excel

8) Every time I make an update to my Worksheet, I would like to add a timestamp to my Last Updated field. In Excel, how can I do that in Worksheet?

9) How can I add interval to dates?

10) How can I add a WorkSheet and name it as required using VBA?


Here the previous and next chapter