Reference functions in different VBAproject

[fboehlandt]

Hi there,
quick question regarding custom functions in VBA. I have an add-in containing several functions that I would like to use in my current VBA project. The add-in has a unique name so I should be able to refer to it. How do I go about doing that? Thankx

 

[xld]

Set a reference to the add-in in your other project, then just call the functions.

 

[fboehlandt]

thanks for the reponse,
that is what I did but no luck there. Here my steps to retrace:
- open the module in my current project (simply named VBAproject) containing the function reference
- Go to Tools, References and then select the relevant project from the scrolldown menu. The project has a unique name VBAMatrix (the bracketed term and name of the actual add-in when using Excel is macro.xla)
- rerun the macro
Again, VBA does not recognize the function reference, although the reference appears directly underneath the module. I assume that one should be able to refer to the function as one would to any other in the same project(i.e. without the application.worksheetfunction prefix). If it helps:
- the functions are recognized in Excel
- the add-in opens automatically whenever I start Excel (hence it is never inactive)
- The relevant function is defined in an Option Private Module
Any ideas please?