Microsoft Excel - How to use Beforeclose event (VBA)

Beforeclose even is useful for running customized code before closing an excel file.

Example

{code}

Private Sub Workbook_Beforeclose(Cancel As Boolean)
    msgbox "Yes I am closing now"
End Sub

{/code}