G
Guest
Is it possible to embed a screentip in a UDF? I'm thinking something along
the lines of the screentips in VBA.
Thank you
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
A UDF can work with cell comments, which are classed as ToolTips, as least
as far as Windows/formatting is concerned.
NickHK
G
Guest
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
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:
N
NickHK
Maybe these will help:
http://www.jkp-ads.com/articles/RegisterUDF01.htm
http://www.bettersolutions.com/excel/EIK284/YN723710331.htm
NickHK
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.
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
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