how to show tooltip on own formula? Possible?

[musa.biralo]

Hi!

I would like to see a tooltip when i type the own formula.. Here is
an example of my own formula...
'---------
Function cvolume(Dia As Double, Height As Double) As Double
cvolume = 3.141592654 * Dia ^ 2 / 4 * Height
End Function
'----------

Is it possible to show tooltip as excel shows while typing a formula..
(without pressing Ctrl+Shift+A)

Appreciate your time!

musa.biralo

 

[Anant.Basant]

Hi!

I would like to see  a tooltip when i type the own formula.. Here is
an example of my own formula...
'---------
Function cvolume(Dia As Double, Height As Double) As Double
cvolume = 3.141592654 * Dia ^ 2 / 4 * Height
End Function
'----------

Is it possible to show tooltip as excel shows while typing a formula..
(without pressing Ctrl+Shift+A)

Appreciate your time!

musa.biralo

Hi,

It is not possible to show argument help for a VBA function, which
shows up in a tooltip.

Anant

 

[musa.biralo]

Thanks for the reply Anant,

then, do you know how it's possible???

musa.biralo

 

[Gord Dibben]

You can show argument help but not ToolTips.

To customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

http://longre.free.fr/english/index.html

Ballon(Tool) Tips are not available with Laurent's method.


Gord Dibben Excel MVP