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 ..."

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
---------------
Jacob Skaria


"Bony Pony" wrote:

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 ..."

Thanks Jacob. Useful tip but no help here I'm afraid :)
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Bony Pony" wrote:

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 ..."

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

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
--
"There are 10 types of people in this world. Those who understand Binary
and those who don''t ..."


"Jan Karel Pieterse" wrote:

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

.

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 ..."

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 ..."


.

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 ..."


.