Use the Add-in from Code

The procedures in this add-in can also be used from Visual Basic code in the test workbook. To use the add-in from code:

  1. From the Visual Basic Editor, choose Tools → References. Visual Basic displays the References dialog.

  2. Select the add-in from the Available References list and click OK.


    The add-in won’t appear in the Available References list if it was not loaded from the Add-Ins dialog, as shown in Figure 22-3.

  3. Write code to test the add-in. Press F2 to view the add-in in the Object Browser as shown in Figure 22-5.

Using the add-in from code

Figure 22-5. Using the add-in from code

Get Programming Excel with VBA and .NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.