+ Reply to Thread
Results 1 to 2 of 2

Display Hints in User Defined Function

  1. #1
    Registered User
    Join Date
    10-16-2020
    Location
    Colombia
    MS-Off Ver
    2016
    Posts
    1

    Post Display Hints in User Defined Function

    Good afternoon.

    I'm new to VBA programming and I'm learning how to create user defined functions. I've created a user defined function (The function is called "Quadratic") that calculates the roots of a square function ax˛+bx+c=0 and recieves as inputs the numbers a, b and c, however, when I use the function in excel and I write in a cell "=QUADRATIC(" I would like to see these little hints that appears like "a;b;c" to know which are the parameters that I have to put in each argument of the function. I would like to know if someone could help me about this questions please? I attach the code here:


    Please Login or Register  to view this content.
    Thanks for your attention and help, have an amazing day.
    Last edited by briannipa; 10-17-2020 at 04:26 PM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Display Hints in User Defined Function

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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] Usage of standard functions into custom function (or user defined function)
    By tusharb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2016, 12:43 AM
  2. COUNTIF/COUNTIFS function + nested user-defined function
    By shamjamali in forum Excel General
    Replies: 1
    Last Post: 05-12-2015, 09:12 PM
  3. User-defined function to compare value to a table and display corresponding value
    By catwithafiddle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-23-2013, 08:01 PM
  4. [SOLVED] User defined function returns an error on a standard function used in it.
    By pb48 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2013, 01:35 PM
  5. Display Expense used up in user defined date range
    By Terrycos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-22-2008, 10:12 AM
  6. Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM
  7. Need to open the Function Arguments window from VBA for a user defined function.
    By korrin.anderson@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2006, 10:55 AM

Tags for this Thread

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