Skip to content

Instantly share code, notes, and snippets.

@joseph4tw

joseph4tw/CallingSubProceduresWithOptionalParameters.vba

Created November 8, 2017 14:06
Show Gist options
  • Save joseph4tw/12b2ffa165ff71f92badc471526ecad0 to your computer and use it in GitHub Desktop.
Save joseph4tw/12b2ffa165ff71f92badc471526ecad0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CallingSubProceduresWithOptionalParameters.vba
Option Explicit
Public Sub DoWork()
Call PrintNumber
End Sub
Private Sub PrintNumber(Optional ByVal number As Long)
Debug.Print number
End Sub
' Output
' 0 (this is because the default for Long is 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment