creating help info for user defined function

  • Thread starter Thread starter Joe Carroll
  • Start date Start date
J

Joe Carroll

I have some custom functions written, and would like to provide a little
note on the function variable input box that explains what the function does
(the same as microsofts functions have tips). Can anyone help with doing
this?
 
Hi Joe,

I sometime use a very basic form of help, Next to where you want to make
the help. Create a graphic box using the drawing toolbar. Then turn this box
into a hyperlink (Just link it to where the box is. Then in the hyperlink
properties there is a button called screen tip ! Here enter you help text
and then when people move the mouse over it they will have a screen tip.

Cheers,

Wayne
 
This won't work like the tips, but it will work if you use the function wizard.

Tools|macro|macros...
type in the name of your function
(you won't be able to select it from the displayed list)

Click the Options button
There's a small textbox where you can type in a short description for that
function.
Click the ok button
then click the cancel button (to dismiss that dialog)

And it could be very helpful if you use nice names for the parms that are being
passed to the function. This would help if the user hits ctrl-shift-a while
entering the formula.

ps. You can use ctrl-a to see the function wizard instead of using the mouse
and clicking on that fx button.
 
Exactly what I was looking for. Thanks Dave.

Dave Peterson said:
This won't work like the tips, but it will work if you use the function
wizard.

Tools|macro|macros...
type in the name of your function
(you won't be able to select it from the displayed list)

Click the Options button
There's a small textbox where you can type in a short description for that
function.
Click the ok button
then click the cancel button (to dismiss that dialog)

And it could be very helpful if you use nice names for the parms that are
being
passed to the function. This would help if the user hits ctrl-shift-a
while
entering the formula.

ps. You can use ctrl-a to see the function wizard instead of using the
mouse
and clicking on that fx button.
Click to expand...
 
Back
Top