Recent Addins ADO Application Arrays Charts Commandbars Count Dates Dialogs Events File access Files & Folders Functions Games Help Import & Export Lookup Off topic Other Outlook PivotTables Power Query Printing Problem solving Read me Searching Sorting Sound Strings Sum Time VBA programming VBE Workbooks Worksheets

Userdefined functions from other workbooks

 2002-07-17    Functions    0    212

You can use a userdefined worksheet function (UDF) from another workbook like this:

=OtherWorkbookName.xls!FunctionName(A1)
If you add a reference in the VBE (press Alt+F11 to open) to the other workbook with the UDF's, you can reference the functions like this:

=FunctionName(A1)
If you make an addin out of your workbook with the UDF's, you can reference the functions like this without creating any references (the add-in must be installed in order for the function to work):

=FunctionName(A1)