View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Embedded function screentip

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