User`s guide

When to Use a Formula Function or a Subroutine
WhentoUseaFormulaFunctionoraSubroutine
VBA provides two basic procedure types: functions and subroutines.
You access a VBA function directly from a cell i n a worksheet as a formula
function. Use function procedures when the original MATLAB function takes
one or more inputs and returns one scalar output.
You access a subroutine as a general macro. Use a subroutine procedure
when the original MATLAB function re turns an array of values or multiple
outputs because you need to map these outputs into multiple cells/ranges
in the worksheet.
When you create a component, Excel Builder produces a VBA module (
.bas
file). This file contains simple call wrappers, each implemented as a function
procedure f or each method o f the class.
2-3