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
Bookmarks