Visual Basic for Applications/Editing Macros

This lesson introduces editing macros.

Objectives and SkillsEdit

Objectives and skills for editing macros include:

  • Setting procedure options by using the Macro Options dialog box
  • Modifying the Visual Basic development environment


  1. Microsoft: Create or Delete a Macro
  2. Excel-Easy: Create a Macro
  3. Microsoft: Run a Macro
  4. Microsoft: MsgBox Function
  5. Home & Learn: The Excel Visual Basic for Applications Development Environment


  1. YouTube: Excel VBA MsgBox Tutorial


'This macro displays a message in a message box.

Sub ShowMessage()
    MsgBox "VBA is fun!"
End Sub


  1. Display content in a message box.
    1. Using Excel, create a new macro that uses MsgBox to display "Hello <your name>!". Insert your name in the macro.
    2. Experiment with running your macro using <F5>, using the Macros dialog box, and assigning a shortcut key.
  2. Run a macro.
    1. Run your Hello macro using a button on the Quick Access toolbar.
    2. Run your Hello macro using a button in a custom tab or custom group on the Ribbon.
    3. Run your Hello macro using a graphic object area.
  3. Run a macro automatically.
    1. Configure your Hello macro to run automatically whenever the workbook is opened Auto_Open.
    2. Test your macro to ensure that it runs automatically.
    3. Test holding down the Shift key to prevent your macro from running automatically.
  4. Research VBA malware.
    1. Review SC Magazine: VBA Malware on the Rise.
    2. Consider how easy it is to create malware using VBA.
    3. Research and consider ways to protect yourself from VBA malware.

See AlsoEdit


  Type classification: this is a lesson resource.
  Completion status: this resource is considered to be complete.