Embedded function screentip

[Bony Pony]

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

 

[Jacob Skaria]

I know this is not what you are looking for; but still it might be useful

Type =SUMIF or any formula in a cell and press Ctrl+Shift+A to get the
syntax as text.

If this post helps click Yes

 

[Jan Karel Pieterse]

Hi Bony,

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.

My xlmenufundict has a sheet which lists most functions with their arguments:

www.jkp-ads.com/download.asp#xlmenufundict

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Peter T]

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]

Thanks Jacob. Useful tip but no help here I'm afraid

 

[Bony Pony]

Hi Jan Karel,
That is a very interesting sheet! While it doesn't give me what I want, it
will prove useful in another project I am planning.

Many thanks for the steer!

Kind regards,
Bony

 

[Bony Pony]

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

 

[Peter T]

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

Regards,
Peter T