found Adding help text to a user-defined function
Finally found a forum discussing this topic.
1. Can someone confirm what is implied above i.e. there is no VBA method to add help to a UDF?
2. Where does the Definition get displayed? Only in the Function text?
My work around is to allow zeros for all parameters as a valid UDF input and then display help text in the cell.
I create a UDF called aaa_HELP (so that it displays at the top of the list). When called, this UDF displays instructions for the all zeros option and gives instructions for formatting the cell to display help text properly i.e. increase cell width, Wrap text and use a fixed width font like Courier New.
Last edited by VBA Noob; 05-28-2008 at 02:16 AM.
Good morning mycroft
...and welcome to the forum!!
The only help you can add to a UDF using unmodified Excel VBA will appear in the description area of the Insert > Function dialog box. Instructions on how to do this are in the link you posted.
If you want to add function help in a tooltip then you'll need to use a third party add-in available for free from here and distribute the .dll files with any copies of your add-in (or make it available to anyone who'll be accessing this file) for it to work properly. I don't actually use this, but I seem to remember last time I checked all the instructions were in French ...
Please familiarise yourself with the rules before posting. You can find them here.
Re: found Adding help text to a user-defined function
My apologies for the tardy response (six years!), but for some reason I never saw your reply. I only found it by accident when searching for my own posts.
I'll have a look at the add-in you suggested. Unfortunately, that will only be on my personal laptop. The IT police at work have Windows so locked-down that I can't even change my desktop colour!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1