Microsoft Excel VBA Stage 1

Microsoft Excel VBA Stage 1

Duration:
1 Day
Aims:

This course is designed to introduce the macro recorder and the VBA editing environment.

Objectives:

Delegates will learn how to write simple procedures and modify recorded code. The course is suitable for those who need to create VBA procedures from scratch and those who have inherited more complex ones and need to understand how they work. The course also provides the foundation for developing your VBA skills further on stage 2.

Pre-Requistites

Attendees should have a very sound knowledge of Excel and be a regular user.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Overview
  • - VBA or Macros?
  • - What it can be used for
Getting Started
  • - Developer tab
  • - Filing
  • - Macro Security
Using the Recorder
  • - Naming Macros
  • - Assigning Shortcuts
  • - Absolute and Relative Recording
  • - Where macros are stored
  • - Personal Macro Workbook
Running Macros
  • - Shortcut keys
  • - Quick Access Toolbar
  • - Worksheets buttons and shapes
  • - Ribbons
The VB Editor
  • - Overview of the VB Editor
  • - Projects and the Project Explorer
  • - Properties and Code Windows
Editing Code
  • - Understanding the code structure
  • - Simple edits
  • - Calling procedures
Stepping and Debugging
  • - Step Intro, Over, Out
  • - Setting Breakpoints
  • - Editing code while Stepping
  • - Dealing with Runtime errors
Writing Macros
VBA Terminology
  • - Procedures, Subroutines, Macros, Functions
  • - Objects, Methods, Properties
Exploring Code with the Immediate Window
Variables and Constants
  • - Dimensioning
  • - Option Explicit
  • - Data Types
  • - Scope
  • - Locals and Watch Windows
The If statements
  • - Single line
  • - Blocked If
  • - Logical expressions
Adding simple Interactivity to Macros
  • - Creating an Interactive Message Box
  • - Creating a Custom Input Box
Related courses
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot