Calling a Public Function

[David]

I'm probably doing something really stupid here, I've got a Public
Function:

Public Function Repayment_Calculator(iRepayment, iTerm)

But when I try to call it from another module like this:

cur_0Tap = Repayment_Calculator(0, int_term)

I get this error:

Sub or function not defined.

So, what did I do wrong this time?

Thanks as usual!

David

 

[Jim Cone]

David,
Your public function should be in a standard module.
Functions are private if they are in ThisWorkbook module or in a
module behind a sheet.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"David"
wrote in message
I'm probably doing something really stupid here, I've got a Public
Function:

Public Function Repayment_Calculator(iRepayment, iTerm)
But when I try to call it from another module like this:

cur_0Tap = Repayment_Calculator(0, int_term)

I get this error:
Sub or function not defined.
So, what did I do wrong this time?
Thanks as usual!
David