Building worksheet functions in an Excel COM addin with VB.Net

[JK]

Hi

I wonder if anyone can help me. I'm looking for information on writing a COM addin for Excel using VB.Net. As well as menus and forms, I need to provide functions which can be used in both worksheet formula and VBA. Am I going about this the right way? Is it possible to do this? If so, can someone point me to some examples.
I'm using VB.Net 2003 and Office 2003

Thanks.

 

[Tim]

The following article can help. It refers to VB6, but you'll get the idea:
http://support.microsoft.com/defaul...port/kb/articles/q291/3/92.asp&NoWebContent=1
HTH

Hi,

I wonder if anyone can help me. I'm looking for information on writing a

COM addin for Excel using VB.Net. As well as menus and forms, I need to
provide functions which can be used in both worksheet formula and VBA. Am I
going about this the right way? Is it possible to do this? If so, can
someone point me to some examples.