Calling a User Defined Function (UDF) from a macro

[Paul_Godley]

I have written a UDf and saved it as an add-in. I can use this from any cell in any sheet and book.
I want to call the UDF from a macro, but cannot figure out how!
Can anybody help please?

 

[Jim North]

Hi Paul,

Welcome to the board!

Function have to be used like:

x = MyUDF(value)

Hope this helps!

 

[Juan Pablo González]

If you want to call it just like it is, you should use the syntax in Test, if you set a reference to the AddIn, you can use the syntax from Test2

<pre>Sub Test()
Dim a
a = Application.Run("MyAddin.xla!MyUDF", 1, 2)
End Sub

Sub Test2()
Dim a
a = MyAddin.MyUDF(1, 2)
End Sub</pre>

 

[Paul_Godley]

Thanks Jim, that was quicker than i expected.

This works fine if the function is in the same book as the calling macro, but not if it's in a different workbook.

 

[Paul_Godley]

Thanks Juan Pablo this works well!