Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF does not show up in Autocomplete
I wrote a function in VBE using excel 2007, saved the workbook
as .xlam, went through excel options to make it available. It works fine, but it does not show up in the autocomplete list. That is, when I type "=" in a cell to get a list of available functions, the UDF is not there. Any ideas? Also, if I get the autocomplete working, how do I get it to list the description and the args? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF does not show up in Autocomplete
hi,
enjoy reading this, http://office.microsoft.com/en-us/ex...010218996.aspx isabelle Le 2013-02-20 12:06, Dom a écrit : I wrote a function in VBE using excel 2007, saved the workbook as .xlam, went through excel options to make it available. It works fine, but it does not show up in the autocomplete list. That is, when I type "=" in a cell to get a list of available functions, the UDF is not there. Any ideas? Also, if I get the autocomplete working, how do I get it to list the description and the args? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF does not show up in Autocomplete
also,
Excel2007 in: Click the "Office". Click "Excel Options". Select the Add-Ins menu. Select "Excel Add-ins" in the menu "Manage" (bottom of the window). Click on "Go". Note: When your workbooks use functions from a supplement, and should be sent to other users, make sure that they also have the supplement. Otherwise, Formulas placed in the spreadsheet will no longer operational and will return an error value # NAME?. isabelle Le 2013-02-20 21:50, isabelle a écrit : hi, enjoy reading this, http://office.microsoft.com/en-us/ex...010218996.aspx isabelle Le 2013-02-20 12:06, Dom a écrit : I wrote a function in VBE using excel 2007, saved the workbook as .xlam, went through excel options to make it available. It works fine, but it does not show up in the autocomplete list. That is, when I type "=" in a cell to get a list of available functions, the UDF is not there. Any ideas? Also, if I get the autocomplete working, how do I get it to list the description and the args? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF does not show up in Autocomplete
On Feb 20, 9:55*pm, isabelle wrote:
also, Excel2007 in: * *Click the "Office". * *Click "Excel Options". * *Select the Add-Ins menu. * *Select "Excel Add-ins" in the menu "Manage" (bottom of the window).. * *Click on "Go". Note: * *When your workbooks use functions from a supplement, and should be sent to other users, make sure that they also have the supplement. Otherwise, Formulas placed in the spreadsheet will no longer operational and will return an error value # NAME?. isabelle Le 2013-02-20 21:50, isabelle a écrit : hi, enjoy reading this, http://office.microsoft.com/en-us/ex...tom-functions-... isabelle Le 2013-02-20 12:06, Dom a écrit : I wrote a function in VBE using excel 2007, saved the workbook as .xlam, went through excel options to make it available. *It works fine, but it does not show up in the autocomplete list. *That is, when I type "=" in a cell to get a list of available functions, the *UDF is not there. *Any ideas? *Also, if I get the autocomplete working, how do I get it to list the description and the args?- Hide quoted text - - Show quoted text - Thanks, Isabelle, but neither post really solved my problem. I already have the function on demand in my spreadsheets. Everything works, but it does not pop up in my autocomplete list. I would like to see it there, along with a brief description and the arguments, because I know I will forget it otherwise. Oddly it does show up in the function list when I hit the "fx" button. Dom |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
UDF does not show up in Autocomplete
hi Dom,
i think this is only possible on the vba editor http://cjoint.com/?CBvupnin0cd isabelle Le 2013-02-21 12:03, Dom a écrit : Thanks, Isabelle, but neither post really solved my problem. I already have the function on demand in my spreadsheets. Everything works, but it does not pop up in my autocomplete list. I would like to see it there, along with a brief description and the arguments, because I know I will forget it otherwise. Oddly it does show up in the function list when I hit the "fx" button. Dom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autocomplete | Excel Programming | |||
AutoComplete | Excel Discussion (Misc queries) | |||
VBA Autocomplete | Excel Discussion (Misc queries) | |||
autocomplete | Excel Programming | |||
autocomplete? | Excel Discussion (Misc queries) |