+ Reply to Thread
Results 1 to 3 of 3

Add a help message to a custom added function

  1. #1
    Registered User
    Join Date
    06-16-2012
    Location
    Evergreen, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    2

    Add a help message to a custom added function

    I've added a custom made function to a spreadsheet. The function works. When I use in-built functions, when I type in the names of the functions I get a grey backed message advising what the function does. I believe it would be called a help message (although I'm not certain that's what it's actual term is, hence the difficulty when looking for help on this).

    Is there a way to add in a help message for my custom built function so when I type it in, it brings up this grey box telling me what the contents of the inputs should be? (Apologies if my description isn't clear).

    Many thanks for any help

    John

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Add a help message to a custom added function

    See if this link helps
    Registering a User Defined Function with Excel
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Registered User
    Join Date
    06-16-2012
    Location
    Evergreen, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Add a help message to a custom added function

    Hi Marcol

    Many thanks for the pointer. I tried to follow what was written, I'm not sure this is exactly what I'm looking for (if I knew the correct terminology it'd be easier for me to communicate what I was talking about).

    Hopefully the following picture is a better way of explaining it.

    Help return on Excel vba.jpg

    When I type in 'Month' as a function it produces the grey box saying 'Returns the month, a number...' etc. When I type in my function 'MonthlyPIPayment' I want to see a grey box advising what the inputted variables are. Any ideas?

    Much thanks

    John

+ 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