User Defined Function Help


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

Advertisements

S

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

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

Advertisements

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top