On Mon, 23 May 2011 20:23:38 -0500, Michael Dobony wrote:

I built a user defined Excel 2007 function with 2 mandatory input variables
and 1 optional variable. Is there any way to display which variable I am
adding like the built-in functions do?

Mike D.

If you enter the formula using the function wizard, and have named your input variables with meaningful names, you can get some prompting that way.

You could use a method shown he http://www.jkp-ads.com/articles/RegisterUDF00.asp

That article also describes that Excel 2010 now allows you to set the Argument Description easily with VBA code.