XLL and function tips
 

Hello,

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

I have done my first functions and it works! :D

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

XLL and function tips
 

You can add a brief description of your UDF by going to ToolsMacroMacros.

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

On 28 Oct 2006 15:40:49 -0700, wrote:

Hello,

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

I have done my first functions and it works! :D

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

XLL and function tips
 

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 :

You can add a brief description of your UDF by going to ToolsMacroMacros.

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