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:
  1. Public Function Test(ByVal a As Double) As Double

  2. Test = a

  3. End Function
...and in VBA
VB Code:
  1. Function ReturnNumber(ByVal v As Double) As Double

  2. Dim obj As ClassLibrary1.ComClass1

  3. Set obj = New ClassLibrary1.ComClass1

  4. ReturnNumber= obj.Test(v)

  5. 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