Excel - User Defined Function Error: This function takes no argume  
Author Message
http://freespace





PostPosted: Fri Aug 18 14:10:02 CDT 2006 Top

Excel Programming >> 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

Excel4  
 
 
Les





PostPosted: Fri Aug 18 14:10:02 CDT 2006 Top

Excel Programming >> Excel - User Defined Function Error: This function takes no argume Can you provide a sample of your function?
i.e
Public Function x(a As Range, b As Range)
x = a * b
End Function
--
Les Torchia-Wells




> 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
 
 
Andrew





PostPosted: Fri Aug 18 14:58:52 CDT 2006 Top

Excel Programming >> Excel - User Defined Function Error: This function takes no argume This can happen if you've inadvertently used the name of an
existing built-in function, e.g.

Function Now(s As String)
Now = 0
End Function

VBA doesn't complain about the name clash but the
Insert/Function dialog will use the built-in function.






> 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

 
 
BruceInCalgary





PostPosted: Wed Aug 23 14:53:02 CDT 2006 Top

Excel Programming >> Excel - User Defined Function Error: This function takes no argume Thanks Andrew and Les for your responses. My client has solved the problem -
there was a Solver Add-In that had to be enabled (under Options/Add-Ins).
There was also a reference to a user-defined function Gasvisc2(pavg, tave,
sg, Co2, n2, h2s) in one of the macros but the function source wasn't
included in the macro module.

Regards, ...Bruce



> This can happen if you've inadvertently used the name of an
> existing built-in function, e.g.
>
> Function Now(s As String)
> Now = 0
> End Function
>
> VBA doesn't complain about the name clash but the
> Insert/Function dialog will use the built-in function.
>
>
>
>
>

> > 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
>
>