User defined functions - parameter descriptions

[Heidi]

Hello,

I have created an Excel add-in containing a number of user define
functions. I would like descriptions of the parameters to show up i
the function wizard.

Does anyone know a way to do this?

Thanks

Heid

 

[Norman Jones]

Hi Heidi,

Go to Laurent Longre's site

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

and download his FunCusomize.zip

 

[Tom Ogilvy]

Download the Addin offered by Laurent Longre which can provide this
functionality:

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

 

[Frank Kabel]

Hi maybe the free-addin FUNCUSTOMIZE.DLL is what you're
looking for (http://longre.free.fr/english)

 

[Heidi]

Thanks for the help everyone. I have downloaded this add-in and followe
the instructions. However, it doesn't seem to be working for me......

I am using Excel 2003. One step of the instructions requires th
following code to be inserted into a module of my xla:

Sub Autpen()
Application.RegisterXLL ThisWorkbook.Path & "\FunCustomize.dll"
Run [FunCustomize], ThisWorkbook.name, shFunctions.Range("A2:Z5")
End Sub

However I am getting an error 424 (object required) on the second lin
of this code......

Any advice would be appreciated.

Heid

 

[Tom Ogilvy]

is
shFunctions

a valid reference to a worksheet?

 

[Heidi]

I have a worksheet named shFunctions in my xla file, so I don't believ
that is the problem. The problem seems to be coming from the attempt t
run the dll, as I have made sure there is no problem with th
parameters I am passing to it

 

[Tom Ogilvy]

unless shFunctions is the code name of your sheet, I would expect it to
raise the error you state.