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

--
Message posted from http://www.ExcelForum.com

Hi Heidi,

Go to Laurent Longre's site

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

and download his FunCusomize.zip


---
Regards,
Norman



"Heidi " wrote in message
...
Hello,

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

Does anyone know a way to do this?

Thanks

Heidi


---
Message posted from http://www.ExcelForum.com/

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

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

--
Regards,
Tom Ogilvy


"Heidi " wrote in message
...
Hello,

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

Does anyone know a way to do this?

Thanks

Heidi


---
Message posted from http://www.ExcelForum.com/

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

-----Original Message-----
Hello,

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

Does anyone know a way to do this?

Thanks

Heidi


---
Message posted from http://www.ExcelForum.com/

.

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 Auto_Open()
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

--
Message posted from http://www.ExcelForum.com

is
shFunctions

a valid reference to a worksheet?

--
Regards,
Tom Ogilvy

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

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

Sub Auto_Open()
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 line
of this code......

Any advice would be appreciated.

Heidi


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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

--
Regards,
Tom Ogilvy

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


---
Message posted from http://www.ExcelForum.com/