+ Reply to Thread
Results 1 to 3 of 3

UDF intellisense constants in formula bar. Possible with vba?

  1. #1
    Registered User
    Join Date
    03-01-2012
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2010
    Posts
    7

    Cool UDF intellisense constants in formula bar. Possible with vba?

    Hi,

    In the Excel 2010 formula bar, if you type
    =MATCH(,,
    you then get a intellisense-style dropdown list of the options available for the third argument in the MATCH function, which are:

    1-Less than
    0 - Exact match
    -1 Greater than


    Does anyone know if/how it's possible to have this dropdown list appear for vba custom formulas that use a set of constants for the user to select from? It really would help if the end user can see the descriptions of the constants in the formula bar.

    Thanks
    Last edited by spetty; 03-03-2012 at 04:33 AM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: UDF intellisense constants in formula bar. Possible with vba?

    Hello spetty,

    Welcome to the Forum!

    Excel only provides intellisense for built-in functions. It would be nice if this feature was extended to UDFs as well. However, it is unlikely Microsoft will ever make such a change to Excel and there is no way to add this capability to Excel either.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    03-01-2012
    Location
    Suffolk, UK
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: UDF intellisense constants in formula bar. Possible with vba?

    Thanks Leith,
    Oh well, nevermind!

+ 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