Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Include help for a user defined function written in C#

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,440
Default Include help for a user defined function written in C#

Hi Torben,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Torben Laursen" wrote in message ...
| 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
|
|


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Include help for a user defined function written in C#

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" wrote in message
...
Hi Torben,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Torben Laursen" wrote in message
...
| 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
|
|




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,440
Default Include help for a user defined function written in C#

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


"Torben Laursen" wrote in message ...
| 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" wrote in message
| ...
| Hi Torben,
|
| Look he
|
| http://www.jkp-ads.com/Articles/RegisterUDF00.htm
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Torben Laursen" wrote in message
| ...
| | 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
| |
| |
|
|
|
|


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Include help for a user defined function written in C#

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

"Niek Otten" wrote in message
...
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


"Torben Laursen" wrote in message
...
| 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" wrote in message
| ...
| Hi Torben,
|
| Look he
|
| http://www.jkp-ads.com/Articles/RegisterUDF00.htm
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Torben Laursen" wrote in message
| ...
| | 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
| |
| |
|
|
|
|






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel fails to update call to user-written function. Jim Luedke New Users to Excel 9 August 28th 09 12:46 AM
Excel - User Defined Function Error: This function takes no argume BruceInCalgary Excel Programming 3 August 23rd 06 08:53 PM
Need to open the Function Arguments window from VBA for a user defined function. [email protected] Excel Programming 0 June 20th 06 03:53 PM
User-defined data type; Error: Only User-defined types... tiger_PRM Excel Programming 1 July 18th 04 03:32 PM
User-Defined Function pre-empting Built-in Function? How to undo???? MarWun Excel Programming 1 August 6th 03 09:31 PM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"