Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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/ . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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/ |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined functions - parameter descriptions
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup, add parameter, on error return user defined value | Excel Worksheet Functions | |||
User Defined Functions | Excel Worksheet Functions | |||
user defined functions | Excel Programming | |||
excel functions and User defined functions | Excel Programming | |||
Using linked workbook as a parameter in a user defined function | Excel Programming |