Screentip in Worksheet User Defined Function

C

Clayman

Is it possible to embed a screentip in a UDF? I'm thinking something along
the lines of the screentips in VBA.

Thank you
 
N

NickHK

Depends what you mean by "screen tip".
A UDF can work with cell comments, which are classed as ToolTips, as least
as far as Windows/formatting is concerned.

NickHK
 
C

Clayman

I hadn't thought about comments, but that would only work after the fact.

I'm thinking more along the lines of the "Intellisense" popups like in the
VBA editor. That will assist the user as they enter the formula. Not as
involved as the Formula Editor, but an assist.

Nevermind - I just figured out why it wont' work. I'm trying to figure out
if I can have Excel prompt the user entering the formula. But if the formula
is home-grown, then it has to be calculated before Excel will even try and
figure out what it does.

OK. :( Bummer.
--
Adios,
Clay Harryman


NickHK said:
Depends what you mean by "screen tip".
A UDF can work with cell comments, which are classed as ToolTips, as least
as far as Windows/formatting is concerned.

NickHK
Click to expand...
 
N

NickHK

Maybe these will help:
http://www.jkp-ads.com/articles/RegisterUDF01.htm
http://www.bettersolutions.com/excel/EIK284/YN723710331.htm

NickHK

Clayman said:
I hadn't thought about comments, but that would only work after the fact.

I'm thinking more along the lines of the "Intellisense" popups like in the
VBA editor. That will assist the user as they enter the formula. Not as
involved as the Formula Editor, but an assist.

Nevermind - I just figured out why it wont' work. I'm trying to figure out
if I can have Excel prompt the user entering the formula. But if the formula
is home-grown, then it has to be calculated before Excel will even try and
figure out what it does.

OK. :( Bummer.
Click to expand...
 
N

NA_AB

hey ppl, i came across this post while browsing through several of them. In
my project which is actually developing a COM addin to ms excel using c#.net,
I am creating my UDFs which are working fine.

But now, I want to be able to show tooltips to these UDFs whenever some one
starts using them in an excel cell in the form of '=my_udf(......)'. I want
to display a tooltip that talks about the number and type of the arguments
'my_udf( )' takes.

Can anyone guide me through this?

Regards,
NA_AB
 
Top