MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do you add tips to function wizard for user defined functions?

Posted by Steve on September 20, 2001 6:30 PM

Is there any way to add tips for a user to see when the insert a function using the automatic wizard?

I have written a couple of functions and have written help files but can not figure out how to add tips like the ones that are displayed when adding a built in Excel function. I am using Excel 97.

Thanks in advance!

Posted by Jay on September 20, 2001 6:43 PM

I'm not sure about this because I'm doing it from memory. It goes something like this;

Select Tools -> Macro -> Macros...

The list of macros will appear but not the custom functions - you need to type in the function. After that, click on "Options..." and enter the information in "Discription" (I think).

Let me know how close I came.


Posted by Steve on September 21, 2001 8:06 AM

Thanks Jay! I followed the above and was able to put a description in as to what the function does, but I could not put in a tip for each argument for the function.

Posted by Jay Deitch on September 21, 2001 12:05 PM

I'm pretty sure there isn't a way to add help/tips for the arguments in a custom function.


Posted by Steve on September 21, 2001 5:50 PM

Thanks for taking the time to respond.