Basic Syntax of VBA

     

     

     

    "Sub" represents to "Sub-Procedure"
    VBA code must be written "Sub" and "End Sub" only

     

    State about Macro Dialogue Box

     

  • Macro Dialogue box consists of
  • Macro Name

    Shortcut Key

    Location where macro stores

    Description

    Here is the brief explanation regarding the Macro Name