Excel Macros and VBA Course 1-Day Course

Description

Excel Macros and VBA Course summary

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

Excel Macros and VBA Course Description

Create simple macros using the macro recorder

Run macros from shortcuts or buttons on the ribbon

Setting Excel Macro Options

Record and Run Simple Macros

Assign Macros to the Quick Access Toolbar

Introduction to the Excel VBA Editor:

Use the VBA Editor to navigate projects and explore object properties.

Create, copy and import/export modules Starting the Visual Basic Editor Using the Project Explorer Using the Properties Window

Creating Procedures and Functions:

Create simple macro procedures in code that use variable to store data and communicate with the user

Creating Sub and Function Procedures

Declare and Use Variables

Displaying Message to the User

Getting Input from the User Controlling Program Flow

Using decision making and looping structures to control the way your program works:

Using the IF Statement

Using the Select Case Statement

Using For Next Loops Using

Do Loops Using For Next Loops

Interacting with the spreadsheet :

Referencing Cells and Ranges

Gathering Cell and Range Information

Using the Offset Method

Using With Blocks

Referencing Workbooks and Worksheets Updating values in the spreadsheet

Functions

Using standard Excel functions in VBA Creating new custom functions

Calling functions and sub procedures

User Form:

Basic design and display,

Getting information via forms and updating cells

Practical project and examples.

What is included in the Excel VBA Courses: