Command Parameter Hints

R

RPS

When entering a worksheet function on the command line, a yellow box with
parameter ordering/option info appears below. A useful remider! However,
there seems to be no info/documentation of what to declear/set when writting
your own VB functions so the same type of hint info will appear when your
function is used. Does anyone know if/how this can be done?
 
G

Gord Dibben

AFAIK this cannot be done.

You can use Laurent Longre's FUNCUSTOMIZE.DLL to show arguments with
descriptions when using the Insert Function feature.

However, this does not provide the "ballon tips/hints" that Excel Functions
do.

BTW "command line" is the Formula Bar

Gord Dibben Excel MVP
 
Top