Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using activex dll from worksheet
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") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you use the ActiveX Calendar control in an Excel Worksheet. | Excel Worksheet Functions | |||
Tab support for worksheet activex controls | Excel Programming | |||
tabbing through ActiveX controls on worksheet | Excel Programming | |||
Problems with worksheet containing ActiveX controls | Excel Programming | |||
Can't check ActiveX checkbox on worksheet | Excel Programming |