Open main menu

Visual Basic for Applications/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

ReadingsEdit

MultimediaEdit

ExamplesEdit

'This macro displays a message in a message box.

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

ActivitiesEdit

  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

ReferencesEdit

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