VBA in Excel Course – Part 1

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, e.g. opening a workbook, pressing a button
• Code user forms for use within workbooks

Versions available

2003, 2007, 2010

Related courses in our range

• Excel Macros Specialist
• VBA in Excel Part 2 - Spreadsheet Developer
• VBA in Excel Part 3 - Application Integration

What does it cover?

The Visual Basic environment

• Project explorer
• Excel objects
• Modules
• Properties window
• Code window

Code structure

• Code structure
• Navigating within your code
• Adding comments
• Using WITH
• Steps to creating a VBA application

Procedures

• Sub procedures
• Event procedures
• Calling procedures

The Excel data model

• Workbook commands
• Worksheet commands
• Excel selection methods
• Data manipulation commands

Statements and functions

• Events and methods
• Statements and functions
• Input boxes
• Message boxes

Debugging

• Using breakpoints
• Stepping through code
• The immediate window
• The Watch window
• The locals window

Error handling

• Error handling routines
• Using ERR

Variables

• Declaring variables
• Declaring multiple variables
• Variable data types
• Concatenation
• Scope of variables

Constants

• Declaring constants
• Using constants
• Scope of constants

Looping

• Do while loops
• Do until loops
• For next loops

Conditional statements

• IF statement
• SELECT CASE statement
• Comparison statements
• Logical operators

Creating a user form

• Form layout
• The control toolbox
• Naming conventions
• Adding objects
• Naming objects
• Captions
• Displaying the form

Object properties

• Object properties
• Setting properties at design time
• Setting properties at run time

Interconnectivity between the user form and Excel

• Comparing values
• Transferring information
• Running code