hey peter, many times I came across this:

http://longre.free.fr/english/index.html

Laurent Longre's website for FUNCUSTOMIZE add-in... but it's again vb! can
yu kindly look into this and tell me what it says?! am not gettin it
100percent.. does it solve my problem?!

Regards,
na_ab

"Peter T" wrote:

AFAIK there is no direct way to do that. To work around with an alternative,
the main problem is code that automates Excel is not asynchronous, which
means while the cell is in Edit mode all code is suspended.

Need look at what's currently in the edit bar, do all the stuff to parse
looking for your UDF, then display a tooltip in the right screen place, and
all that while in Edit mode.

I'm not saying the task is impossible but I'm not aware of anyone having
done it. Even without the Edit mode problem there is still a lot to do.
Unless some 'back-door' way in is exposed it would be quite a task. Thinking
aloud, would need to sub-class window events of the edit bar and go from
there; maybe doable if someone's up for the challenge, but I think I'll
pass!

Regards,
Peter T


"NA_AB" wrote in message
...
hey ppl, 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