2

I would love to be able to add tooltip/dropdown/popup to my user-defined Excel 2010 functions.

The similar thing can be seen from VLOOKUP function as below screenshot.

If you know how to create it, please share.

enter image description here

Improve this question

1 Answer 1

Reset to default
2

Its not possible to do this (but you can do it for the function wizard with Automation or XLL)

Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

If it is not possible, why VLOOKUP can have it?
Would you make it more clearer on Automation or XLL? Thank you!
There is no programmable published interface to do this: but the Excel development team can.
For Automation addins or VBA UDFs see jkp-ads.com/Articles/RegisterUDF00.asp for C++ XLLs see msdn.microsoft.com/en-us/library/bb687883.aspx
And for UDFs defined in .NET, Excel-DNA (exceldna.codeplex.com) makes the wizard customization easy.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.