+ Reply to Thread
Results 1 to 4 of 4

Help Text for Add-in

  1. #1
    Registered User
    Join Date
    05-27-2005
    Posts
    11

    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.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996
    In lieu of a full-blown help document, you can:

    Tools>Macro>Macros

    -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

  3. #3
    Registered User
    Join Date
    05-27-2005
    Posts
    11

    Using Macro Description

    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

  4. #4
    Registered User
    Join Date
    05-27-2005
    Posts
    11

    It Does Work

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

    Thankyou

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1