Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a Public Function
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a Public Function
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling Public Variables between diff Modules | Excel Programming | |||
Calling? Invoke Public Function | Excel Programming | |||
Using A Public Function / | Excel Worksheet Functions | |||
Calling a Public Subroutine in a Different Workbook | Excel Programming | |||
Public Function | Excel Discussion (Misc queries) |