Help for 'homemade' function

  • Thread starter Thread starter Franz Mayer
  • Start date Start date
F

Franz Mayer

Hi Folks,

I have a Excel97-Function with five parameters and now I want to
explain these function with its parameters for users. They should read
a little explaination if they press the "Paste Function"-Button (it's
this fx - button). There are only the names of the var's of my
function, but nothing more.

Is this possible in Excel 97? And at it's best without any further
program!

Thanx. Franz
 
Make those variable names nice and then

Tools|Macros|Macros...
type in the function name (it won't appear in the list)
click on options
type in your description
click ok to return to previous dialog
click cancel (yes, cancel)

test by typing your formula in the formula bar
=yourfunction(
click on the fx button

(Stolen from Norman Harker a few years ago.)


There's not too much room there, so you mght hv to abbrev yr wds.
 
Dave Peterson said:
Make those variable names nice and then

Tools|Macros|Macros...
type in the function name (it won't appear in the list)
click on options
type in your description
click ok to return to previous dialog
click cancel (yes, cancel)

test by typing your formula in the formula bar
=yourfunction(
click on the fx button
Click to expand...

so far so good. it works. thanks for your hint!

but now it would be nice, if i could also give some explaination-text
for the variables. Furthermore I would like to see the type of var's
after the enter field of each. In each 'normal' function it is like
that. then after the enter field you can something like 'number',
'logical', 'text' and so on.

Thanks for tips!

regards, Franz
 
Back
Top