Great Minds, Always Changing

Excel VBA Outline

During this VBA session you will be shown how to automate and customise Excel using macros and controls, such as buttons and menus. Delegates learn how to write macros using VB code and assign macros to screen items

Course details

Using the Macro Recorder

  • Recording a Macro
  • Using Absolute references
  • Personal Macro Workbook
  • Assigning shortcut keys
  • Deleting Macros
  • Using Relative references

Creating and Editing Macros using VBA

  • Macro storage concepts
  • The VBA Editor
  • Program Components
  • Introduction to Editing code
  • Copying and Pasting procedure
  • Linking Procedures
  • Create and user a user-defined function
  • Auto-executable macros

Objects and Dialog Boxes

  • Introduction to Objects
  • The Object browser
  • User defined dialog boxes – message and input boxes

Introduction to Controls

  • Worksheet Controls
  • Creating User forms

Level

Advanced

Duration

1 day (but can be run as shorter sessions)

Course Requirements

Delegates should have a good grounding in Excel and be familiar with absolute vs relative cell referencing, functions and formula syntax, pivot-tables and sheet linking. Familiarity with the macro recorder would be an advantage.

Contact

Email the Training Team for more information and availability at training@prosperity247.com