XLL and function tips

[swell]

Hello,

I have started a project for school, and i have to do a XLL.

I have done my first functions and it works!

But here is my problem:

When in the workbook if I type =SUM( Excel will tell me the arguments
Now if I type =MyFunc( Excel won't show anything. Is there a way to
have it working?

TIA

 

[Gord Dibben]

You can add a brief description of your UDF by going to Tools>Macro>Macros.

Type in the name of your UDF and hit "Options". Add a description and hit OK
then Cancel. Yes......Cancel.

To actually add the arguments you will need something more complex.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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

UNFORTUNATELY................Ballon/Screen Tips are not available with Laurent's
method.


Gord Dibben Excel MVP

Hello,

I have started a project for school, and i have to do a XLL.

I have done my first functions and it works!

But here is my problem:

When in the workbook if I type =SUM( Excel will tell me the arguments
Now if I type =MyFunc( Excel won't show anything. Is there a way to
have it working?

TIA

Gord Dibben MS Excel MVP

 

[swell]

Hi Gord!

Thanks for your answer, but I was looking for the ballon tips...
Is there a way to have it? Or is it impossible?

Thanks again

Gord Dibben a écrit :