From http://www.w3schools.com (Copyright Refsnes Data)
Sub procedure
The sub procedure does not return a value.
Function procedure
The function procedure is used if you want to return a value.
We have two kinds of procedures: The Sub procedure and the Function procedure.
A Sub procedure:
Sub mysub() some statements End Sub or Sub mysub(argument1,argument2) some statements End Sub |
A Function procedure:
Function myfunction() some statements myfunction=some value End Function or Function myfunction(argument1,argument2) some statements myfunction=some value End Function |
When you call a Function in your code, you do like this:
name = findname() |
Here you call a Function called "findname", the Function returns a value that will be stored in the variable "name".
Or, you can do like this:
msgbox "Your name is " & findname() |
Here you also call a Function called "findname", the Function returns a value that will be displayed in the message box.
When you call a Sub procedure you can use the Call statement, like this:
Call MyProc(argument) |
Or, you can omit the Call statement, like this:
MyProc argument |
From http://www.w3schools.com (Copyright Refsnes Data)