An organisation development specialistLinked In

Macros VBA

Duration 2 days

Course Content

Simple Macros

  • Recording a Macro
  • Running a Macro
  • Using the Visual Basic Toolbar
  • Making Macros Easier to Use
  • Adding to the Tools Menu
  • Assigning to a Button on a Sheet
  • Assigning to a Toolbar Button
  • Assigning to a Graphic Object
  • Macro Storage
  • Relative & Absolute References


Viewing & Modifying Visual Basic Code

  • Module Sheets
  • Reading Visual Basic Code
  • Statements
  • Comments
  • Rem Statements
  • Keywords
  • Keystrokes used in a Module Sheet
  • Editing Code
  • Deleting Unnecessary Code
  • Making Long Statements Readable
  • Customising Code
  • Making a Macro Interactive
  • Recording Code into an Existing Macro

Making Macros Make Decisions

  • Control Structures (Decision Making)
  • If...Then
  • If...Then...Else
  • Control Structures (Looping)
  • Do Loop


Objects

  • Object Properties
  • Common Properties
  • Object Methods
  • Toggling the Property of an Object


On-Sheet Controls

  • Placing Controls on the Worksheet
  • Setting the Properties of a Control
  • Linking Controls to Worksheets 




 

More