Help for 'homemade' function

[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

 

[Dave Peterson]

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.

 

[Franz Mayer]

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

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