tooltip in Excel

Jul 23, 2014 at 11:08 PM
Is there a way to create a tooltip/prompt for a UDF? I.E. if I type '=vlookup(' I am prompted with the names of the parameters. I was hoping the ExcelArgument tag would do this, but it only seems to populate the function box (or what ever you call the prompt that comes up when you hit 'fx').
Jul 24, 2014 at 9:55 AM

Excel does not support the in-sheet IntelliSense for user-defined function of any type - .xll, VBA or whatever.

I have started a project to work around this ( but at this stage it's just an experiment to try a few ideas, and I've not had a chance to take it much further.

Jul 24, 2014 at 2:27 PM
Thanks. I will keep an eye on the IntelliSense project.