Finally found a forum discussing this topic.
http://www.excelforum.com/showthread.php?t=577764
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.
Bookmarks