Learning Visual Basic For Microsoft Excel

  1. Home
  2. Excel-vba
  3. Learning Visual Basic For Microsoft Excel

Tags: Excel VBA

Master Visual Basic for Excel, learn to unlock the true power of Excel. Tutorial Taught by a leading Microsoft Expert

Last updated 2022-01-10 | 4.7

-

What you'll learn


* Requirements

*

Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this Visual Basic for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. This course starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.

The tutorial extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This Visual Basic for Excel tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.

By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn Visual Basic for Microsoft Excel in this video tutorial.

Course content

12 sections • 90 lectures

Getting Started 6 lectures

Working Files - Download These First Preview 00:01

What Will I Get Out Of This Course Preview 03:56

The Excel Working Files Explained Preview 03:00

What Is VBA For Excel? Preview 05:07

Excel 2010 Security Settings And Macro Files Preview 03:44

The Developer Ribbon Preview 01:54

Macros 5 lectures

Recording And Running A Simple Macro Preview 03:51

Editing An Existing Macro In The Visual Basic Editor Preview 03:59

The New Macro Enabled File Type Preview 02:22

Quick Tour Of The Excel Visual Basic Editor Preview 06:00

Watch A Macro Write Your VBA Preview 02:58

Procedures And Functions 5 lectures

What Is A Module? Preview 03:19

Creating A Sub Procedure Manually Preview 03:14

How To Call A Sub Procedure Preview 02:49

Creating A Function Procedure Preview 02:51

How To Call A Function Preview 02:57

Getting Started With VBA Programming 11 lectures

Using Comments Within Your VBA Code Preview 03:58

Declaring Variables And Data Types Preview 05:29

The Scope Of A Variable Preview 04:49

The Static Declaration And Variable Expiry Preview 04:53

Constants Instead Of Variables Preview 03:39

An Intrinsic Constant Preview 03:07

String And Date Types Expanded Preview 06:04

Excel VBA Operators Preview 07:50

Arrays Preview 05:07

Multi-Dimensional Arrays Preview 03:32

Dynamic Arrays Preview 03:22

Manipulating Excel Objects 10 lectures

Referencing Cells Using The Range Object Preview 05:28

The CELLS Property Preview 02:46

The OFFSET Property Preview 02:29

The VALUE Of Ranges Preview 07:43

The TEXT Object Of The RANGE Preview 03:01

A Number Of Read Only RANGE Properties Preview 09:06

The FONT Property And Colors Preview 08:20

Formatting Numeric Values Preview 03:24

Add Formulas To Cells Through VBA Code Preview 06:36

Common METHODS Of The RANGE Object Preview 11:46

Working With Excel VBA Functions 6 lectures

What Is A Function? Preview 01:30

Built In VBA Date Functions Preview 02:29

Text Manipulation With VBA Functions Preview 03:53

Determining File Sizes Using FILELEN Preview 02:34

Using Worksheet Excel Functions In VBA Code Preview 08:09

User Defined Functions In Excel Preview 04:35

Controlling Program Flow And Execution 8 lectures

Using GOTO And Labels Preview 04:25

Controlling The Program Flow With IF THEN ELSE Preview 04:23

Multiple Criteria Plus Nested IFs Preview 05:27

Adding ELSEIF To Speed Up Execution Preview 04:07

SELECT CASE As An Alternative To IF Preview 04:24

The FOR NEXT Loop Preview 09:25

FOR NEXT With A VBA Collection Preview 06:32

DO WHILE Loop Preview 06:56

Events 7 lectures

How To Create An Event Preview 06:57

WorkBook Events - Open Preview 08:17

Workbook Events - Closing And Saving Preview 07:32

Workbook Triggers - Activate And Deactivate Preview 05:12

Worksheet Triggers - Activate And Deactivate Preview 04:15

Other Useful Worksheet Triggers Preview 09:44

Using Application Events Preview 12:06

Debugging And Error Handling 8 lectures

Error Trapping the Easy Way Preview 07:38

Make The VBA Ignore Errors Preview 04:12

Interact With The User When An Error Occurs Preview 04:58

Making Use Of The ERR Object Preview 04:14

Debugging Techniques Preview 06:11

Using Breakpoints To Help Debug Preview 05:45

Setup And Use A Watch Preview 05:04

Speeding Up The VBA Tips Preview 12:50

Interacting With Users Through Forms 17 lectures

Using MSGBOX To Interact With Users Preview 09:05

Use INPUTBOX For Accepting Values From Users Preview 07:19

Selecting A Range With The INPUT Box Preview 04:05

An Introduction To UserForms Preview 04:06

Creating A UserForm Preview 04:22

Using Command Buttons In Excel Preview 05:17

Adding Option Buttons In A Frame Preview 05:12

Adding The Code That Makes The Form Work Preview 07:17

Calling Your UserForm And Validating Content Preview 08:05

UserForm Controls - The CheckBox Preview 08:10

UserForm Controls - ListBox And/Or Combo Box Preview 10:10

Images On UserForms Preview 05:24

Labels And Text Boxes Preview 05:30

Multiple Tabs On A UserForm Preview 08:10

Allowing The User To Highlight A Range Preview 04:13

Scrollbar And Spin Controls Preview 08:18

Controlling Tab Order And Aligning Controls Preview 08:48

Running And Storing VBA Code 6 lectures

Trigger A Procedure From The Quick Access Toolbar Preview 05:05

Customizing The Ribbons Preview 05:06

Adding Buttons To Sheets Preview 03:51

Adding A Keyboard Shortcut Trigger Preview 02:46

Where To Store Your VBA Code Preview 07:38

Adding Code To The PERSONAL File Preview 08:09

Summary 1 lectures

So What's Next? Preview 02:27