Include help for a user defined function written in C#

[Torben Laursen]

Hi

I have a COM written for Excel 2003 using C# and VSTO with a number of user
defined functions (UDF) that I write.

When the user click on "Insert function" inside Excel to bring up the window
where he can see and change all the function arguments I would like to
include my own help information where the user can click on "Help on this
function".

Does any one know how this can be done?

Thanks Torben

 

[Niek Otten]

Hi Torben,

Look here:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi
|
| I have a COM written for Excel 2003 using C# and VSTO with a number of user
| defined functions (UDF) that I write.
|
| When the user click on "Insert function" inside Excel to bring up the window
| where he can see and change all the function arguments I would like to
| include my own help information where the user can click on "Help on this
| function".
|
| Does any one know how this can be done?
|
| Thanks Torben
|
|

 

[Torben Laursen]

Niek,

Thanks for the link.

I looked at it and it seems a very primitive way to do this.
Is there not a simpler way to include help in UDF inside Excel?

Torben

 

[Niek Otten]

Hi Torben,

<a very primitive way>

Quite the contrary.
It is complex indeed. Many experts have tried to solve this and what Jan Karel presents is the first ever complete solution, based
on the work of Laurent, KeepITCool and many others.
I can imagine you'd like something more straightforward. So do I. But please don't call this solution primitive; at last there IS
a solution!
And NO, there is no simpler way. At least, not one we or any of the experts know of.
A better solution is top of the wish-list of me and, I think, quite a few other Excel MVPs.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Niek,
|
| Thanks for the link.
|
| I looked at it and it seems a very primitive way to do this.
| Is there not a simpler way to include help in UDF inside Excel?
|
| Torben
|
|
| | > Hi Torben,
| >
| > Look here:
| >
| > http://www.jkp-ads.com/Articles/RegisterUDF00.htm
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > | Hi
| > |
| > | I have a COM written for Excel 2003 using C# and VSTO with a number of
| > user
| > | defined functions (UDF) that I write.
| > |
| > | When the user click on "Insert function" inside Excel to bring up the
| > window
| > | where he can see and change all the function arguments I would like to
| > | include my own help information where the user can click on "Help on
| > this
| > | function".
| > |
| > | Does any one know how this can be done?
| > |
| > | Thanks Torben
| > |
| > |
| >
| >
|
|

 

[Torben Laursen]

Niek,

You are right I should have used a better phrase, sorry!

I guess that I am getting use to everything is very easy when using C# and
other tools is visual studio 2005.

Torben