| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
Hybrid Mode
