+ Reply to Thread
Results 1 to 5 of 5

Excel Function Tooltip

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Excel Function Tooltip

    Hello,

    I have a number of functions in VBA, and I'd like to have a tooltip to be displayed while entering the function. For example, entering CTRL +SHIFT + A works well, but I'd like to share the functions with other users, not always familiar with VBA (Alt + F11).
    Also, how can a "proper" help message be created for such module with functions.
    Any help would be much appriciated.

    For example, for function:
    Please Login or Register  to view this content.
    =Discount_Factor(rate,n_period)


    Thanks,
    Marcin

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Excel Function Tooltip

    AFAIK, this isn't possible in VBA, though some people have tried a C# solution with moderate success.

    You can add descriptions to the function dialog though (the fx button), which may serve your needs well enough.

    Example:

    Please Login or Register  to view this content.
    Result:

    Function Argument.png
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Registered User
    Join Date
    02-26-2014
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Excel Function Tooltip

    Thanks. How can I get this to work? When copied into VBA editor, what is the next step please?

  4. #4
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Excel Function Tooltip

    Run the code. Next time you use your function, press the Fx button. You'll see what I showed above.

  5. #5
    Registered User
    Join Date
    02-26-2014
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Excel Function Tooltip

    WOW. It really works. Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to put a tooltip on a user-defined function
    By chief_abound in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2015, 05:52 AM
  2. How to add a ToolTip in MS Excel 07?
    By jcavigli in forum Excel General
    Replies: 6
    Last Post: 02-01-2013, 12:45 PM
  3. how to customise the text to show in tooltip or mousehover on excel chart
    By kavita.kabbur in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2012, 04:39 AM
  4. excel dynamic tooltip
    By miri_t in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-03-2012, 11:16 AM
  5. Tooltip for Excel picture button
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2010, 04:43 AM
  6. Accessing Tooltip Data in an Excel Chart
    By MikeM in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-30-2006, 03:35 PM
  7. [SOLVED] User Defined Function (UDF) Tooltip
    By Chris Shorrock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2005, 01:05 PM

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