Help Text for Add-in
 

I have created an add-in. The add-in is displayed in the "Insert
Function" dialog. For example from the menu:
Insert
Function
Select the function named ABS

There is a help sentence in the lower part of the dialog:
ABS(number)
Returns the absolute value of a number...

However with my custom function, the help section of the function
dialog is blank when I select the function. "No help available"

My question is, how do I include custom help text to display in the
function dialog?

Thanks in advance for your assistance.


--
bjoeylouie
------------------------------------------------------------------------
bjoeylouie's Profile: http://www.excelforum.com/member.php...o&userid=23819
View this thread: http://www.excelforum.com/showthread...hreadid=374746

Help Text for Add-in
 

In lieu of a full-blown help document, you can:

ToolsMacroMacros

-Enter your function name
(because functions don't automatically display)

-Click the [Options] button

-Enter a short description of the function

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=374746

Help Text for Add-in
 

This is a nice idea. However there are 15 functions and add-in will be
used by 10 office co-workers. I'm thinking one would have to import
the macros for each spreadsheet.

I've been looking at other add-in that I have, there is no description.
I'm beginning to think this is not possible. Although I'm going to do
some research on accessing Excel dialogs.

Any other thoughts?

Dave


--
bjoeylouie
------------------------------------------------------------------------
bjoeylouie's Profile: http://www.excelforum.com/member.php...o&userid=23819
View this thread: http://www.excelforum.com/showthread...hreadid=374746

Help Text for Add-in
 

You are a genius. This does work even when I move the add-in to another
machine.

Thankyou


--
bjoeylouie
------------------------------------------------------------------------
bjoeylouie's Profile: http://www.excelforum.com/member.php...o&userid=23819
View this thread: http://www.excelforum.com/showthread...hreadid=374746