Skip to content

Instantly share code, notes, and snippets.

@joseph4tw

joseph4tw/CallingSubProceduresWithParameters.vba

Created November 8, 2017 13:02
Show Gist options
  • Save joseph4tw/84ac06d0b624f1a5d20a6c0a6e811ae8 to your computer and use it in GitHub Desktop.
Save joseph4tw/84ac06d0b624f1a5d20a6c0a6e811ae8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CallingSubProceduresWithParameters.vba
Option Explicit
Public Sub MyPublicSub()
Call MyPrivateSub("John", 28)
MyPrivateSub "John", 28
End Sub
Private Sub MyPrivateSub(name As String, age As Long)
Debug.Print name + " is " & age & " years old."
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment