Embedded function screentip

B

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
 
J

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
 
J

Jan Karel Pieterse

P

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
 
B

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
 
B

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
 
P

Peter T

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

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top