change function variable prompts??

T

thinkingfield

Anyone know how to change the prompts for a custom function when you us
the 'insert function' menu?

For instance, you highlight a cell and go to 'insert' - 'function' o
the menu bar. A dialogue box pops up where you can populate all th
variable needed for the function. The prompt next to each box is th
variable name given in the function subroutine. I would like to pu
more explicit names that contain spaces instead of the variable name.

Any help?? thanks!!!
 
L

LanceB

Even though user defined functions will not show up in the Run Macro
dialog, you can TYPE the name into this dialog. Use Tools/Macro/Macros, type
the name of your function, then click the Options button. Enter the
description in the text box shown, and this will be shown to the user as in
VLOOKUP, etc.

Lance
 
Top