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.

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


On Mon, 27 Sep 2004 23:12:40 -0400, "Marc Deveaux" wrote:

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.

"Marc Deveaux" wrote in news:ubg8HkQpEHA.2340
@TK2MSFTNGP11.phx.gbl:

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.

"Jonathan Rynd" wrote in message
. ..
"Marc Deveaux" wrote in news:ubg8HkQpEHA.2340
@TK2MSFTNGP11.phx.gbl:

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.

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