Createing Excel Function in VB.Net

[TinoWendisch]

Hi,
I would like to create excel functions in VB.NET. So far no problem, for example:

In VB.NET (using a COM class):

Public Function Test(ByVal a As Double) As Double
Test = a
End Function

...and in VBA

Function ReturnNumber(ByVal v As Double) As Double
Dim obj As ClassLibrary1.ComClass1
Set obj = New ClassLibrary1.ComClass1
ReturnNumber= obj.Test(v)
End Function

My two questions are:

Is it possible to create an excel function in VB.NET without going through a wrapper function in VBA? I have heard, if you do it in C# this is possible.

Secondly, is there a way to generate help text for the function arguments (displayed in the function editor in VBA)?

Many thanks for the help.

Tino

[sparrow1]

Is it possible to create an excel function in VB.NET without going through a wrapper function in VBA? I have heard, if you do it in C# this is possible.

Hi,

I think it is possible to create an Excel Function in VB.Net.

See this link:

http://msdn.microsoft.com/library/de...HV05205786.asp

Hope it helps,

sparrow1

[TinoWendisch]

Thanks, will have a look at it.
Tino