VBA (or other) worksheet function parameter insight
 

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.

VBA (or other) worksheet function parameter insight
 

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.

VBA (or other) worksheet function parameter insight
 

"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.

VBA (or other) worksheet function parameter insight
 

"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