VBA (or other) worksheet function parameter insight

[Marc Deveaux]

Is there a way to get Excel XP (or later) to display the parameters to a
worksheet functions as the user types in the same way as the built in
functions do.

I am not referring to the function wizard (fx), but the yellow background
control tip that appear below the cell when the open bracket '(' of vlookup
is typed, the parameter name appears in bold as each parameter in filled in.
In VBA/Visual Studio this is called Quick Info or Parameter info.

Any info welcome.

 

[Myrna Larson]

No. The best you can do is the function wizard.

 

[Jonathan Rynd]

Is there a way to get Excel XP (or later) to display the parameters to a
worksheet functions as the user types in the same way as the built in
functions do.

Not with a worksheet function written in VBA, but if you build an XLL you
can.

 

[Fredrik Wahlgren]

Not with a worksheet function written in VBA, but if you build an XLL you
can.

Is this true even if you create a UDF as an automation add-in? I have one
that won't compile because I now have a newer version of Office. It's a C++
add-in.

/ Fredrik