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

Thank you
--
Adios,
Clay Harryman

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

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

Thank you
--
Adios,
Clay Harryman

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" wrote:

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

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

Thank you
--
Adios,
Clay Harryman

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

NickHK

"Clayman" wrote in message
...
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" wrote:

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

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

Thank you
--
Adios,
Clay Harryman

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

"NickHK" wrote:

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

NickHK

"Clayman" wrote in message
...
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" wrote:

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

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

Thank you
--
Adios,
Clay Harryman