VBA in Excel Course: Part 1

Book this course

Course description

Microsoft’s Visual Basic for Applications (VBA) is a powerful tool when used in conjunction with Excel – enabling you to get so much more out of the software.

We show you structures, syntax, and coding standards, providing you with the fundamental technical skills you need in order to competently create code in VBA.

Is it right for me?

Our VBA in Excel Part 1 course is an introduction to Visual Basic programming in Excel and looks at structures, syntax and coding standards.

This course is designed for existing experienced users of Excel.  You must be confident creating and manipulating Excel spreadsheets and creating formulas before attending this course.  You must be able to record and run macros.

Previous programming experience would be an advantage.

 

What will I get out of it?

By the end of the course you will be able to:


  • Write Visual Basic procedures
  • Use the Excel Data Model to manipulate data on worksheets
  • Store data using variables and constants
  • Automatically run code when events occur, such as opening a workbook or pressing a button
  • Code user forms for use within workbooks

The course provided a good grounding in VBA. The trainer had excellent knowledge of the subject and transferred this across well, was helpful during the practical examples and encouraged a good way of thinking when working in VBA.

 

Asset & Performance Analyst, Cubit Transport Systems Ltd

What does it cover?

  • Project explorer
  • Excel objects
  • Modules
  • Properties window
  • Code window
  • Code structure
  • Navigating within your code
  • Adding comments
  • Using WITH
  • Steps to creating a VBA application
  • Sub procedures
  • Event procedures
  • Calling procedures
  • Workbook commands
  • Worksheet commands
  • Excel selection methods
  • Data manipulation commands
  • Events and methods
  • Statements and functions
  • Input boxes
  • Message boxes
  • Using breakpoints
  • Stepping through code
  • The immediate window
  • The watch window
  • The locals window
  • Error handling routines
  • Using ERR
  • Declaring variables
  • Declaring multiple variables
  • Variable data types
  • Concatenation
  • Scope of variables
  • Declaring constants
  • Using constants
  • Scope of constants
  • Do while loops
  • Do until loops
  • For next loops
  • IF statement
  • SELECT CASE statement
  • Comparison statements
  • Logical operators
  • Form layout
  • The control toolbox
  • Naming conventions
  • Adding objects
  • Naming objects
  • Captions
  • Displaying the form
  • Object properties
  • Setting properties at design time
  • Setting properties at run time
  • Comparing values
  • Transferring information
  • Running code

Book this course

Course leader

Richard Harker

Technical & Digital Learning Consultant

Need a bespoke solution?

Talk to us about setting up a course that is tailor made for you.

Latest insight from Thales L&D

Free download

Enhance Magazine - Issue 19

Welcome to our latest issue of Enhance. Businesses are facing ever more challenging times in terms of global and local...

Read full article

Blog article

How Prepared are You? Episode Two: An Ageing Workforce

With all the changes I see occuring, one of the questions I'm most interested in is: how are organisations preparing...

Read full article

White paper

A Useful Guide to L&D Curriculum Design

Employee engagement has become one of the most frequently cited buzzwords in the HR and L&D world, and with good...

Read full article