Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 Add-ins and UDF's
Excel 2007
When I start to enter a function into a worksheet cell, there is a dropdown box that appears with a list of all the possible functions starting with that letter (letters). The same holds true if the function is a UDF that I have written in that particular workbook. It also occurs if the function is part of the morefunc.xll add-in. However, it does not occur if the function is a UDF coming from an add-in -- at least if the add-in is an .xla file. Any solutions? --ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 Add-ins and UDF's
I haven't tried it but does setting a reference to the add-in in the VBE
help? -- Jim "Ron Rosenfeld" wrote in message ... | Excel 2007 | | When I start to enter a function into a worksheet cell, there is a dropdown box | that appears with a list of all the possible functions starting with that | letter (letters). | | The same holds true if the function is a UDF that I have written in that | particular workbook. | | It also occurs if the function is part of the morefunc.xll add-in. | | However, it does not occur if the function is a UDF coming from an add-in -- at | least if the add-in is an .xla file. | | Any solutions? | --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 Add-ins and UDF's
On Mon, 7 Apr 2008 11:32:41 -0400, "Jim Rech" wrote:
I haven't tried it but does setting a reference to the add-in in the VBE help? Let me see ... Just tried that and no, it doesn't. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF's | Excel Discussion (Misc queries) | |||
How do I use UDF's in Excel 2007 from 2000 | Excel Programming | |||
UDF's using other UDF's | Excel Worksheet Functions | |||
What UDF's are being used? | Excel Programming | |||
UDF's | Excel Programming |