Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

To create a Macro:

  • Go to View >> Macro's >> View Macro's
  • Type name of Macro "Greetings" (Note the extra "s" on the end, that is On Purpose and comes in later)
  • Select "Create"
  • Note: In the future, to open VBA Editor use Alt+F11
  • Enter Macro:
Sub Greeting()
  'Greet user.

  MsgBox "Greetings", vbOKOnly, "Greetings"

End Sub

To Run a Macro:

  • Press Alt+F8
  • Select Macro
  • Hit Run

You should see a simple Greeting Box!

You have just installed a Macro and ran it!

  • No labels