Diference between Sub and Function

[BShadow]

Hello people,

I was wondering, what is the diference between an sub and a function? Other than the fact that the function itself can be returned as a variable.

When creating Class modules and normal Modules, what is the reason for using a sub and for using a function?

[Si_the_geek]

You have basically answered your own question, the fact that a function returns a value is the only difference.

You only need to use a function if for some reason you want it to return a value, eg:

Function Min(ByVal valueA, ByVal valueB)
'Returns minimum of two values, or nothing if incompatible types
'(first value if equal)
 
  On Error Resume Next
  Min = IIf(valueB < valueA, valueB, valueA)
 
End Function