Show Function Description in "Insert Function Dialog box"

I

isaacvarghese

Hi All,

I'm developing and Automation addin for Excel 2003 using VS.NET 2005
(C#). I was successful in creating the function and it's working as
expected.

But my issue is that I couldn't find a way to show a brief description
in the Insert Function Dialog box. Inside the dialog box i can see my
function name with parameter list, just below the "Select a Function"
List box. And in place of description a test appears "No help
available".

Can some one suggest me the way to achieve this?

On searching various articles/forums, I found that in VBA you can
achive this using "Application.MacroOptions _
Macro:="TestMacro", _
Description:="This function gives back the 'Hello world'
message!", " etc.

Any code samples/ direction in this respect would be really
appreciated.

Thanks in advance for your help.
Isaac Varghese
 
I

isaacvarghese

Hi Isaac,

Please see if the following article can be of help for You:
Registering a User Defined Function with Excelhttp://www.jkp-ads.com/Articles/RegisterUDF00.htm

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel:http://xldennis.wordpress.com/
My English site:http://www.excelkb.com/default.aspx
My Swedish site:http://www.xldennis.com/
Click to expand...

Dennis,

Thanks for the response and the links. As mentioned in that doc, it
may not be the right way of doing it + it's in VBA.

I was just wondering, Are there no API's available in C# to do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List of function descriptions and field descriptions 0
Function Description 1
descriptive/help texts for parameters in automation addin (vb.net) 0
Creating custom dialog box in Excel COM add-in using C++ 4
formula description and argument display 1
How do you document a function (like built in functions) in VBA? 1
Deploying an Excel 2003 Automation addin (C#) 1
User Defined Functions in Automation Addin behave differently in 2 0

Top