CODEWITHSUNDEEP
excelvba
NCC
NCC

Reputation: 819

How to show hints when writing function in Excel?

Every built-in Excel functions has a hint when typing

For example,something like

=SUM([Number1,Number2,....

I wonder if it is possible to implement something like this when writing customized function?

Thanks.

Upvotes: 0

Views: 1151

Answers (1)

Siddharth Rout
Siddharth Rout

Reputation: 149277

AFAIK you cannot do that. What you can do however is add descriptions to your UDFs.

Having said that you can use Application.MacroOptions to add descriptions. For example

Sub Sample()
    Application.MacroOptions Macro:="MyFunction", _
                         Description:="This function does Blah Blah", _
                         Category:="My Custom Category"
End Sub

SNAPSHOT

enter image description here

If you want, you can also add a help file to it as shown in this link.

Upvotes: 2

Related Questions