Show input names in my own VBA-functions

[Tenshu]

Hello

I am a beginner with VBA. My question is fairly simple: When I create new functions with VBA, can I have them show the input names when I call them in Excel? For instance if I use the default if-function, it will state that the first input should be the logical test, the next should be the value if true etc. I would like that to be the case as well for my own functions.

Best regards,
T

[AndyLitch]

if you declare it as a public function then yes...

[HaHoBe]

Hi, Tenshu,

maybe have a look at Register UDFs.

Ciao,
Holger

[JS411]

To clarify, you can use VBA to register the UDF's arguments to be displayed when using the Insert Function dialog from the Ribbon, as shown in the link provided by Holger.

As far as I know, there is no way to have the arguments appear in the Formula Box (labeled fx) the same way they do for built-in functions like IF() in your example. At least not as of xl2010.