Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
No argument list showing in UDF
Hi there
I have written a few user-defined functions all stored in the same module but some of them do not give the argument list when I use them within an excel sheet. I have tried copying the code to different modules, copying the bulk of the code to a new module and then creating a new Function name and argument list, even pasting the code into word and then repasting it back into a new excel session with a blank worksheet/module but I still have the same problem. Any ideas why this is the case and how to fix it? Many Thanks Lloyd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
No argument list showing in UDF
On 25 Jan 2006 06:37:08 -0800, "
wrote: Hi there I have written a few user-defined functions all stored in the same module but some of them do not give the argument list when I use them within an excel sheet. I have tried copying the code to different modules, copying the bulk of the code to a new module and then creating a new Function name and argument list, even pasting the code into word and then repasting it back into a new excel session with a blank worksheet/module but I still have the same problem. Any ideas why this is the case and how to fix it? Many Thanks Lloyd You should be able to see an argument list if you use the Insert Function wizard (click the little Fx at the left end of the formula bar). --ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
No argument list showing in UDF
Thanks Ron.
But I have tried that as well as using Ctrl+A shortcut key but for some of my UDFs there is still no argument list coming up... Aaarrrrggggghhhhhh! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list showing different value | Excel Discussion (Misc queries) | |||
drop down list is not showing | Excel Discussion (Misc queries) | |||
Creating and showing a list | Excel Discussion (Misc queries) | |||
Function (array argument, range argument, string argument) vba | Excel Programming | |||
Pop-up function argument list | Excel Programming |