Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 18th 06, 07:57 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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

  #2   Report Post  
Old August 18th 06, 08:10 PM posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 240
Default 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


"BruceInCalgary" wrote:

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

  #3   Report Post  
Old August 18th 06, 08:58 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 225
Default 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.





BruceInCalgary wrote:
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


  #4   Report Post  
Old August 23rd 06, 08:53 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 2
Default Excel - User Defined Function Error: This function takes no ar

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

"Andrew Taylor" wrote:

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.





BruceInCalgary wrote:
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to open the Function Arguments window from VBA for a user defined function. [email protected] Excel Programming 0 June 20th 06 03:53 PM
Error messages from user defined Excel worksheet function Tom Ogilvy Excel Programming 3 March 18th 06 04:30 PM
#Name? Error in User Defined VB Function idgity Excel Worksheet Functions 2 August 30th 05 08:58 PM
How to create User Defined function in Excel Johnny Ko Excel Programming 2 December 5th 03 09:09 AM
User-Defined Function pre-empting Built-in Function? How to undo???? MarWun Excel Programming 1 August 6th 03 09:31 PM


All times are GMT +1. The time now is 02:39 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017