Sub Vs. Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike H. - 26 Sep 2007 11:14 GMT

Would someone please be so kind as to compare and contrast the differences
between a sub and a function. Thank you.

Reply to this Message

Chip Pearson - 26 Sep 2007 11:25 GMT

A Function procedure can return a result to the calling procedure, while a
Sub procedure does not return a result:

Sub AAA()
Dim L As Long
L = MyFunction(2)
MsgBox L
End Sub

Function MyFunction (T As Long)
MyFunction = T * 10
End Function

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

> Would someone please be so kind as to compare and contrast the differences
> between a sub and a function. Thank you.

Reply to this Message