Difference Between Sub Procedure and Function Procedure

Sub Procedure

Function Procedures

Sub Procedure is procedure that performs some action.

Function Procedure also perform some action but also returns some value to point from which it was called

Syntax for Sub Procedure is as follows:

Private Sub <procedure name>

‘ Actions to performed

End Sub

Syntax for Function Procedure is as follows:

Private Function Commission()

‘ Action to performed

Commission = <value that to be return>

End Function

Example:

Form_Load()

Example:

Val(), FormatPercentage()