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 wrote:
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