+ Reply to Thread
Results 1 to 3 of 3

found Adding help text to a user-defined function

  1. #1
    Registered User
    Join Date
    05-27-2008
    Location
    Saigon
    MS-Off Ver
    Windows Excel Professional Pro 2010
    Posts
    11

    found Adding help text to a user-defined function

    Finally found a forum discussing this topic.

    http://www.excelforum.com/showthread.php?t=577764

    1. Can someone confirm what is implied above i.e. there is no VBA method to add help to a UDF?

    2. Where does the Definition get displayed? Only in the Function text?

    My work around is to allow zeros for all parameters as a valid UDF input and then display help text in the cell.

    I create a UDF called aaa_HELP (so that it displays at the top of the list). When called, this UDF displays instructions for the all zeros option and gives instructions for formatting the cell to display help text properly i.e. increase cell width, Wrap text and use a fixed width font like Courier New.
    Last edited by VBA Noob; 05-28-2008 at 02:16 AM.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good morning mycroft

    ...and welcome to the forum!!

    The only help you can add to a UDF using unmodified Excel VBA will appear in the description area of the Insert > Function dialog box. Instructions on how to do this are in the link you posted.

    If you want to add function help in a tooltip then you'll need to use a third party add-in available for free from here and distribute the .dll files with any copies of your add-in (or make it available to anyone who'll be accessing this file) for it to work properly. I don't actually use this, but I seem to remember last time I checked all the instructions were in French ...

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    05-27-2008
    Location
    Saigon
    MS-Off Ver
    Windows Excel Professional Pro 2010
    Posts
    11

    Re: found Adding help text to a user-defined function

    domincb,

    My apologies for the tardy response (six years!), but for some reason I never saw your reply. I only found it by accident when searching for my own posts.

    I'll have a look at the add-in you suggested. Unfortunately, that will only be on my personal laptop. The IT police at work have Windows so locked-down that I can't even change my desktop colour!

+ 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