Unfortunately there's no direct way to get the tooltips directly from the
function.

Regards,
Peter T

"Bony Pony" wrote in message
...
Hi,
Thanks for the steer. I know what the text is, I want to access it
directly
from the function.

When I get my hands on Excel 2010, I know there will be new or modified
functions from 2007. I want to be able to compare the current functions
(which I have listed) and x-ref them against new ones.

Kind regards,
Bony
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."


"Peter T" wrote:

You asked this question on 03Nov but as you are using MS's web interface
(communities) you will not have seen my reply (NNTP posts made since
02Nov
are just getting through to the web interface today, there have been
technical problems).

Here's my previous suggestion again, given in addition to the others

see Peter Noneley's Excel Function Dictionary
http://www.xlfdic.com/

Regards,
Peter T

"Bony Pony" wrote in message
...
Hi all,
Is there a way to "get" the actual screentip text that Excel displays
in
the
Insert Function dialog box when a particular function is selected?

What I am trying to achieve is to be able to use a native Excel
function
as
a string and then get the associated properties assigned to that
function
from deep within the heart of Excel.

e.g. in col A I have the name of the function - SUMIF
In col B I want to automatically populate the internal screentip
associated
with that function.
In Col C I want to put the associated syntax and operands.

I truly doubt this is possible!

Kind regards,
Bony
--
"There are 10 types of people in this world. Those who understand
Binary
and those who don''t ..."


.