View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Franz Mayer Franz Mayer is offline
external usenet poster
 
Posts: 2
Default Help for 'homemade' function

Dave Peterson wrote in message ...
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