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

On 25 Jan 2006 06:37:08 -0800, "lloyd.greensite@googlemail.com"
<lloyd.greensite@googlemail.com> 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

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!