User Defined Function Help

  • Thread starter Thread starter Michael Dobony
  • Start date Start date
M

Michael Dobony

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.
 
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?
Click to expand...

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.
 
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.
Click to expand...

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])".
 
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.
Click to expand...

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])".
Click to expand...

Than ks.

You would need to write your function within an .xla or .xlam add-in,
not a regular workbook. You would need to publish your help text
within the add-in. I'm sorry, I know it can be done, but I don't
know how.
 
Back
Top