Functions

Hi Anna

A Function always returns a value. The value is assigned to the name of the function

To create a function in VBA do the following:

[Public] Function FunctionName ([Argument list] as Type

Public Function Area (Length As Single, Width As Single) As Single

Area = Length * Width

End Function

Hope this helps

Carlos