• Business Functions
• Summary
• Function Selector
• Function Finder
• Trace
• Help
• Function Examples
• Tutorials
• Monte Carlo
• GoalSeek
• Utilities
• Callable from VBA
• Array Functions
• CashFlow Administrator
• Select Function
• Number Formats
• Functions Overview

Callable from VBA

• All Business Functions are easily callable from VBA, so you can use them either for your own custom functions or within a macro.
• Example Custom Function:
  Function RentAndFitout(Time,Base,fitout,FromDates,Rents,Expiry,MktRent,GrowthDates,GrowthRates)
  Dim myrent, myfit
  myrent = Run("fsteprentgrow",Time,Base,Expiry,MktRent,FromDates,Rents,GrowthDates,GrowthRates,60,0,6,4,1)
  myfit = Run("mkpmts",Time,Base,FromDates(1),fitout)
  RentAndFitout = myrent - myfit
  End Function
• You can also do this with Array functions.
• You will suffer a performance penalty if you use VBA - the above example is 4 times slower than using the 2 'native' Business Functions in a cell.