Excel Basic VBA Instructions (VBA 3)

Current Status

Price

65 $

Get Started

Take this Course

Excel Basic VBA Instructions

Discover the fundamental instructions of the VBA language

Objectives:

Master the loops useful for executing programmed instructions several times
Mastering conditional statements (if)

Learn how to ensure the proper functioning of VBA programs, debugging and error handling

Duration: 7 hours

Prerequisites:

Advanced user with a good command of Microsoft Excel and having experienced macros-commands

Back to the course list

Back to participant profile

Course Content

Lesson Content

0% Complete 0/3 Steps

Theory of loops ( Duration : 05:29 )

Do loops ( Duration : 07:44 )

For loops ( Duration : 12:52 )

Lesson Content

0% Complete 0/4 Steps

Simple conditions ( Duration : 08:28 )

Multiple conditions ( Duration : 10:55 )

Select case conditions ( Duration : 04:51 )

Conditions and loops ( Duration : 04:45 )

Lesson Content

0% Complete 0/5 Steps

Syntax error ( Duration : 03:05 )

Execution error ( Duration : 03:16 )

Compilation error ( Duration : 02:17 )

Logical error ( Duration : 04:58 )

On Error GoTo ( Duration : 04:56 )

Lesson Content

0% Complete 0/3 Steps

Using existing functions ( Duration : 08:02 )

Creating a custom function ( Duration : 05:33 )

Example of internet verification ( Duration : 02:42 )

Lesson Content

0% Complete 0/1 Steps

Training manual