There have been a few User Defined Functions submitted as KB entries recently. Is it possible for Excel to show Function Tips for UDFs the way it does for built-in functions?
Regards
MD
There have been a few User Defined Functions submitted as KB entries recently. Is it possible for Excel to show Function Tips for UDFs the way it does for built-in functions?
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Yes, but you have to put them in the excel sheet where you would assign shortcuts...ALT-F8 > EDIT > Options
YOu can type the description there.......I have not yet figured out how to do that bit programattically yet though...but that is where the option is to put a description of the function...
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Hi guys,
Mr Laurent Longre have an add-in that may be useful in this context:
http://xcell05.free.fr/ (Click on the English-button)
Kind regards,
Dennis
If I am on track with what you are asking for.......you can use MacroOptions to assign some basic text about what the function does....there are some others methods I have seen, but none reliable besided the method Laurent Longre provides in Dennis's link
Justin Labenne
Thanks all,
It was this display I was thinking of.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Is that display a new feature?
I don't seem to have it in Excel 2000.
It's a 2003 feature. I happened across a blog on Excel 12, and I see that Intellisense is coming to the worksheet, so maybe I'll just have to wait.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
It was implemented in XL2002 aka XP.Originally Posted by Norie
Patrick
I'm guessing this can't be done, or in any case not easily.
Thanks for the help.
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'