PDA

View Full Version : Sleeper: Function defintion in comment



lior03
06-12-2005, 01:34 PM
hello
during the course of time i came across dozens of user define excel functions.
to each function i added through the alt +f8 combination little description.
my question- is it possible to add this description to a cell i used this function in as a comment.
thanks
moshe

MWE
06-12-2005, 02:29 PM
hello
during the course of time i came across dozens of user define excel functions.
to each function i added through the alt +f8 combination little description.
my question- is it possible to add this description to a cell i used this function in as a comment.
thanks
moshe
you could simply copy the text from the VBE and paste it to the comment field for the target cell.

Bob Phillips
06-12-2005, 05:10 PM
to each function i added through the alt +f8 combination little description.
my question- is it possible to add this description to a cell i used this function in as a comment.

If you mean can you do this from within the function, the answer is no, you can't change worksheet attributes with a UDF.