Using activex dll from worksheet

[Steve Garman]

I have an activex dll on my system.

In VB5 (not VBA) I can set a reference to xyFunctions
I can then call the function func1() with two variant arguments and it
returns a variant.

''''''''''''''''''''''''''
Private xy As xyFuncs

Private Sub Command1_Click()
Dim ret As Variant, arg1 As Variant, arg2 As Variant
Set xy = New xyFuncs
arg1 = "ABC"
arg2 = "DEF"
ret = xy.func1(arg1, arg2)
MsgBox ret
End Sub
''''''''''''''''''''''''''''

Is there a way that I can refer to this activex dll in Excel, such that
it can be used as a worksheet function?

If this is possible, could someone please explain how in words of one
syllable, as I'm feeling particularly stupid on this issue.

Please note that, while it would be nice to be able to pass cell
references to it, I would settle for the ability to call it with
literals, such as:
=xyFunctions.func1("ABC","DEF")

 

[Rob van Gelder]

HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions
http://support.microsoft.com/default.aspx?kbid=285337

 

[Steve Garman]

Thanks Rob,

I knew I was missing something obvious. I just forgot the "Automation"
button was on the Add-ins dialog