Screen Tip/Auto Completion For UDFs

[FARAZ QURESHI]

Excel 2007 sure does provide a good feature of auto completion in case of
entering a built-in function so as to select one from the recommended list
instead of typing the whole. However, the UDFs I have defined in an AddIn are
not being presented so.

Any idea to overcome this and have your UDFs be listed as well?

 

[Shane Devenshire]

Hi,

User defined function which are in the spreadsheet are included in the
AutoComplete list. So the problem lies in the fact that the functions reside
in another workbook. I tested and it makes no difference whether the
workbook containing the functions are Add-ins or Regular files.

If someone doesn't come up with a solution one approach you might consider
is having copies of the function code loaded into each workbook when they are
opened.