I developed a function and stored this in an Excel-Addin File named "myAddins.xlam" together with a macro (sub) that I have developed before. The Macro is visible as Macro in the settings menu for ribbons and can then be executed. But I cannot use the function in my Visual Basic Editor, the compiler says "Sub or Function not defined".
Any ideas ?
2019-02-08_20-50-09.jpg
2019-02-08_20-51-29.jpg
2019-02-08_20-53-45.jpg
I think this sounds like a case where you are neglecting to set a reference to the add-in containing the function. I have only encountered this rarely, so I am not very knowledgeable, but something like this should explain: http://www.cpearson.com/excel/References.htm
Originally Posted by shg
Hello MrShorty
Maybe it doesn't look the same in Windows and Mac, but it is the same as cpearson references in his description:
2019-02-08_20-50-09.jpg
What are the two () doing after the String in GetArray Function?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Hmm ... I am not good enough to teach others, but it works in this way.
As I understand the () marks it as an one-dimensional array of strings.
I always use a variant and never used this.
One way or other there is something missing then or is the parameter that you pass of another type then the dimensionned type?
Hello Keebellah
Ok, I can explain what this function is for, but in general the function works and is not the problem. Stored directly in my project, the function works as expected. Therefore I would like to go back to my question, except you think that the definition of the return value has something to do with the compile problem ...
@MrShorty: This was really close ! But it could not solve my problem immediately. I was searching around and have found a better better description:
https://www.fontstuff.com/vba/vbatut08.htm
if you create a .xlam, then you have to reference this twice
- One time within the workbook that is using this .xlam you will find in the menu "Development Tools" the button "Excel-Add-Ins". If you activate this check box, the .xlam will be visible in your VBA Editor and you can also find your Macros (Sub) listed in the Macros Menu for Execution.
- To use the functions inside the .xlam you have also to register the .xlam project in the VBA-Editor. There you will find your .xlam listed in the Project Browser. Click on this and give it first a better name (e.g. myAddins instead of VBAProject). Then select in the Project Browser your current project in that you want to use the functions from your .xlam and click in the VBA-Editor Toolbar to Tools -> References. Now you have a dialog box with all the external libraries and you will find your myAddins project. Click the checkbox there and your functions can be used as normal functions in your current project.
You can also add the code to open the xlam on workbookopen event.
Don't forgte to close the xlam workbook beforeclose event
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks