It is true that from the UI perspective a UDF appears to be part of
XL's functions. However, it is not really so. It is part of the XLA
that contains it. Adapt the idea at
How to use a class (object) from outside of the VBA project in which it
is declared
http://support.microsoft.com/default...b;en-us;555159

specifically, see how the function New_clsEmployee is accessed
externally. If the rest of the stuff about classes and objects is
confusing, just ignore it.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , Andibevan@notehere-
hotmail.com says...
Hi All,

I have a UDF that is contained in an add-in I have created myself
(MyAddin.xla)

I have been trying to utilise the UDF as follows:-

Var_TXT = application.worksheetfunction.myextract(Var_Source _Fold,1,"B","\")

But keep getting this error "Object doesn't support this property or method"

Any pointers?

Ta

Andi