Excel Macros and VBA 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 FunctionsCreate 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: