View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Help for 'homemade' function

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