No argument list showing in UDF

[lloyd.greensite]

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

 

[Ron Rosenfeld]

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

 

[pinkfloydfan]

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!