On Mon, 23 May 2011 22:03:26 -0400, Stan Brown wrote:

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?

Maybe it's just me, but what do you mean by "display which variable I
am adding"? Maybe an example of what you're trying to do would help.

When you type in a function name and put in the first parentheses there is
a window that opens up below the cell to tell you the inputs that the
function requires. Type "=fv(" in a blank cell and the help window below
shows "FV(rate, nper, pmt, [pv], [type])".