I just discovered that if you add a description to a custom excel formula (i.e. a user-defined function, VBA function, or whatever you want to call it) and then cut and paste the VBA code (so as to move it to a different spot in the VBA module for example), the description gets erased!. This can be frustrating if you have a lot of custom formulas created and documented.
By the way, what I mean by a "description" is that after you create the UDF, you go to Tools > Macros > Macros, then enter the name of the formula in the Macro Name: text box. The Options button will magically be enabled, allowing you to edit the description (which of course shows up when you use the Insert > Function feature in Excel - the whole point to wanting to add a description in this manner).
No comments:
Post a Comment