Description

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time.

Course overview

Duration: 2 days (13 hours)

Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards.

This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code.

Objectives

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

Write visual basic procedures

Create event and general procedures

Use commands from the Excel data model

Use statements and functions

Use a selection of debugging tools

Create and use variables and constants

Use different types of loops

Create an Excel user form

Content

The VBA 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 procedure

Procedures

Sub procedures

Event procedures

Calling procedures

The Excel data model

Workbook commands

Worksheet commands

Excel selection methods

Data manipulation commands

Debugging

Using breakpoints

Stepping through code

The immediate window

The watch window

The locals window points

Variables and Constants

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

Course Images

VBA in Excel - Part 1

By Underscore Group

Booking options

Highlights

Description

About The Provider

Tags

Reviews