Use a UDF in an XLA in the VBA code of another workbook

[Jubinell]

Hi,

I've created a UDF which I've stored in an .xla file fired up in Excel and ready use. In fact it works great in the worksheet of any workbook. However when it comes to VBA and I try to use this UDF Excel tells me it can't recognize the function.

How make the UDF universal in both worksheets and VBA codes?

 

[tusharm]

See
How one VBA project can use an object declared in the class module of another project
http://support.microsoft.com/kb/555159

While the above deals with a class object, the concept is the same as for a function. Treat New_clsEmployee as the function of interest.

 

[Jubinell]

I'm not sure I follow. The first instant of New_clsEmployee that I see in the document is this function.

Option Explicit
Public Function New_clsEmployee() As clsEmployee
    Set New_clsEmployee = New clsEmployee
    End Function

If New_clsEmployee is my UDF, then what is clsEmployee? Do I also need the code a few lines above?

Option Explicit
Dim sName As String
Property Get Name() As String
    Name = sName
    End Property
Property Let Name(uName As String)
    sName = uName
    End Property

 

[tusharm]

For your work that's not the important part. See how the function is called from the example subroutines.

 

[Jubinell]

Umm...not sure if this is what you're trying to get at, but I went to Tools - Reference in the VBA environment and put a tick next to my .xla.

Then I was able to call the function as is. No additional work needed.