Createing Excel Function in VB.Net

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

In VB.NET (using a COM class):

VB Code:

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

...and in VBA

VB Code:

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 :wave:

Quote:

---

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

Thanks, will have a look at it.
Tino :)