Excel user-defined function show arguments in a cell

[StuckInTheMiddle]

Hi All,

I was wondering if anyone ever found a solution for Question2 posed in this really old thread thread68-902827

I also have a UDF in Excel that I would like to be able to have the arguments ‘toolips’ automatically show when a user types the formula for my function in to an Excel cell, much like what happens when you type =SUM(

Any help much appreciated.

A,


"If you can stay calm, while all around you is chaos...then you probably haven't completely understood the seriousness of the situation.

 

[firefytr]

No, you can't do that. The best you can do is to use something like Funcustomize.dll by Laurent Longre..

http://xcell05.free.fr/english/

.. which allows you to customize the Function Wizard screen.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[StuckInTheMiddle]

After many many hours of researching I have to agree with you that there appears to be no easy/native way of doing this.

Thanks anyways firefytr, I've taken a look at this and unfortunately requesting that my users to have a DLL installed (lots and lots of remote users) isn't a realistic option.

A,


"If you can stay calm, while all around you is chaos...then you probably haven't completely understood the seriousness of the situation.

 

[GlennUK]

Have a look here:

http://www.jkp-ads.com/Articles/RegisterUDF02.htm

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.