View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BruceInCalgary BruceInCalgary is offline
external usenet poster
 
Posts: 2
Default Excel - User Defined Function Error: This function takes no argume

I have a user defined VBA function in my Excel spreadsheet. I do an Insert
- Function and then I select the user-defined function from the function
list. Excel should then display a Function Arguments form prompting for the
parameters for this function, but instead, Excel displays the mesasge "This
function takes no arguments.". This works on some PCs but not others and the
problem occurs with Excel 2002 and Excel 2003. I have looked at the
references in VB but there doesn't seem to be anything missing. Any help
would be greatly appreciated!

Regards, ....Bruce