VBA Custom Functions

[Sumifs]

Hi,

I have a custom function which I created in VBA for Excel. The VBA was originally saved in a module in each Excel file that I was using it with however this has resulted in version control issues whenever I need to make any code changes. I have since switched to saving the VBA as an add-in for Excel which works much better.

My question is, that if I run the add-in while opening a file that contains the same function in a module, which version of the function would Excel use when it calculates? I can test this and find out for myself but I was just wondering if someone might be able to provide a more technical explanation.


Thank you in advance for any help or input!

 

[alansidman]

I put custom functions (UDFs) in my personal.xlsb file. That file is stored in the XLStart folder and loads each time excel opens. It is hidden. Look at this link on creating a personal file.

How do I create and use a PERSONAL file for my VBA code