how to show tooltip on own formula? Possible?
 

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

how to show tooltip on own formula? Possible?
 

On Apr 7, 2:20*am, "musa.biralo" wrote:
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

how to show tooltip on own formula? Possible?
 

On Apr 6, 8:22 pm, wrote:
On Apr 7, 2:20 am, "musa.biralo" wrote:



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
'----------
Thanks for the reply Anant,

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

musa.biralo


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

how to show tooltip on own formula? Possible?
 

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

On Sun, 6 Apr 2008 17:51:41 -0700 (PDT), "musa.biralo"
wrote:

Thanks for the reply Anant,

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

musa.biralo