Difference between SUB and function

[juhuwoorps]

Hi at all!

I'm curios to know whats the difference between a Sub routine and a function!

So far I have seen there is no big difference, but there must be one because its splitted.

So please help me to understand this!

TiA juhu

[ShadowHunter]

Hi,

Sub: accepts values but doesn't return something
Function: like sub but can return a value

Example:

Sub Add (X As Integer ,Y As Interger)
MsgBox "Sum is" & X+Y
End Sub

Function Add (X As Integer ,Y As Interger) As Integer
Add = X+Y
End Function

So, here Add will have the value of X+Y

Hope this makes sense

With best regards,

ShAdOwHuNtEr