ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Addins - Calling an addin function from within VBA code (https://www.excelbanter.com/excel-programming/364877-addins-calling-addin-function-within-vba-code.html)

Guy Normandeau

Addins - Calling an addin function from within VBA code
 
I have several functions that are created and stored in an addin. I can use
all these functions as they were designed, except, from within VBA code for
this worksheet.

I have declared the function in the addin as public but i cannot seem to be
able to access it from within VBA in my new workbook.

What can i do to access these frunctions.

Thanks

Guy Normandeau

Ardus Petus

Addins - Calling an addin function from within VBA code
 
Name your VPA Project Addin with a definite name.
Within VBE; ToolsReferences, check your project

HTH
--
AP

"Guy Normandeau" a écrit dans le
message de news: ...
I have several functions that are created and stored in an addin. I can
use
all these functions as they were designed, except, from within VBA code
for
this worksheet.

I have declared the function in the addin as public but i cannot seem to
be
able to access it from within VBA in my new workbook.

What can i do to access these frunctions.

Thanks

Guy Normandeau





All times are GMT +1. The time now is 06:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com