User Defined Function Help

[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.

 

[Stan Brown]

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.

 

[Ron Rosenfeld]

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 here: 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.

 

[Michael Dobony]

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

 

[Stan Brown]

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

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.