Visual Basic for Applications - Excel VBA - The full course
3.1 (115 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,963 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Visual Basic for Applications - Excel VBA - The full course to your Wishlist.

Add to Wishlist

Visual Basic for Applications - Excel VBA - The full course

Learn how to do macros in EXCEL VBA and applications to automate Microsoft Excel with Visual Basic for applications
3.1 (115 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,963 students enrolled
Created by Daniele Protti
Last updated 5/2017
English
Learn Fest Sale
Current price: $10 Original price: $100 Discount: 90% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 22 hours on-demand video
  • 3 Articles
  • 17 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • create your own macro in Excel
  • program in VBA
  • understand Visual Basic for Applications
  • create automated reports in Excel
  • develop your applications and tools in Excel
View Curriculum
Requirements
  • Microsoft Excel
  • Microsoft Word
Description

The course is composed of more than 200 videos. Each lesson is composed of one of more videos. The videos are created by experts developing applications using Visual Basic for Application (VBA) for MS Excel or MS Access for small, middle and large companies as consultants and as managers and coach for internal processes. These experts have created complex tools to create the reporting structure and manage the business processes. An extended version will include also real examples to be used directly in working and office processes.

You will learn from the basic concepts to the principles to build your own applications in Excel using VBA.

You will understand and digest the concept of object oriented programming and remove your barriers from being scared to see programming code.

You will be able to retrieve data from databases or other files and present them in Excel files.

You will create automated procedure to format data, display information and create complex reports and graphs.

Who is the target audience?
  • software developers
  • accounters
  • employees in HR, Finance, Accounting
  • Business Analysts
  • Business Intelligent developers
  • Project manager
  • Quality managers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 263 Lectures Collapse All 263 Lectures 32:57:37
+
Introduction
2 Lectures 16:10

Introduction the VBA - Visual Basic for Applications - The Complete Course

Preview 04:17

Overview of Visual Basic for Applications (VBA):

What is Visual Basic for Applications (VBA)

VBA and Microsoft Excel

What is Object Oriented Programming in VBA

What are the Objects in Excel and how to refer to them via VBA

Preview 11:53
+
Overview of VBA and of the tool
8 Lectures 56:39

Introduction to Visual Basic for Applications (VBA)

How to access and use VBA in Microsoft Excel

How to record a macro in VBA

How to run a macro in VBA

How to edit a macro in VBA at your needs

The power of Excel with VBA, The VBA code, Recording, Saving and Running Macros
12:02

Overview of Excel version 2013

Overview of the Excel Application as a Tool (Version 2013)
03:00

Macro Security
05:37

How to protect a Worksheet in Excel

How to protect a Worksheet in Excel and make some cells only scrollable and/or selectable

How to protect a VBA Project from being viewed

Preview 07:53

How to access the VBA Editor or VBE

The property window in VBE

The List of Projects and Modules in VBA

Where to find Forms and Modules in VBE

How to add a Form or Module in VBA

VBE – The VBA editor, VBA toolbar (Part I)
10:12

The VBE Menu

The VBA Toolbar

Where to find the commands and objects for Forms in VBE

How to edit the content of a Form in VBE

How to edit the code of a Form in VBE

Write your code in VBE


VBE – The VBA editor, VBA toolbar (Part II)
07:28

Overview of the VBE in the version 2013

VBE – The VBA editor, VBA toolbar - Version 2013
06:23

Overview of the Developer Ribbon in Excel version 2013

The Developer Ribbon
04:04
+
The VBA language
2 Lectures 18:12

How to write your code in Visual Basic for Applications (VBA)

How to assign VBA code to Excel Objects

The Steps to write a simple VBA code

Understanding the code, Remove the concept “VBA is HARD!”, The Debugging tool
07:57

What is an Object in Visual Basic for Applications (VBA)

What are Methods, Events and Properties of an object in Visual Basic for Applications (VBA)

Analyze a recorded macro in Visual Basic for Applications (VBA)

VBE to analyze recorded macros, Objects, Methods, Properties, Code cleaning and
10:15
+
Functions, subroutines, constants and variables
7 Lectures 30:07

What is a Function in Visual Basic for Applications (VBA)

What is a Sub or Subroutine in Visual Basic for Applications (VBA)

Public and Private Functions and Sub in Visual Basic for Applications (VBA)

Private and Public functions and subroutines, variables by val and optional vari
07:08

The difference between a Function and a Sub in Visual Basic for Applications (VBA)

Variables in Visual Basic for Applications (VBA)

Constants in Visual Basic for Applications (VBA)

Functions, subroutines, constants and variables
06:35

In thie quiz you will evaluate your knowledge about the difference between functions and subroutines and their properties

Recap on Functions and Subroutines
1 question

Type of variables in Visual Basic for Applications (VBA)

Private and Public variables in Visual Basic for Applications (VBA)

Variables, Private and Public variables
07:40

What is the difference between variables and constants

Recap on Variable and Constants
4 questions

Function declarations in Visual Basic for Applications (VBA)

Declare functions
03:32

Explicit or Implicit variables in Visual Basic for Applications (VBA)

Explicit and Implicit declarations in Visual Basic for Applications (VBA)

Options: Explicit, Implicit
01:34

How to declare a variable in Visual Basic for Applications (VBA)

How to declare a function in a library in Visual Basic for Applications (VBA)

What is a Type in Visual Basic for Applications (VBA)

How to declare Types in Visual Basic for Applications (VBA)

Declare variables, declare functions in libraries, Types
02:22

Define the dimension of a variable in Visual Basic for Applications (VBA)

Re-define the dimension of a variable at runtime in Visual Basic for Applications (VBA)

Modify the dimension of variables in Visual Basic for Applications (VBA)

Dimension variables (Dim, Redim, Redim Preserve)
01:16

Verify your knowledge about the size of a variable set

Dimension variables
1 question
+
Objects
5 Lectures 34:16

Details on Objects in Microsoft Excel and how to refer to them in Visual Basic for Applications (VBA)

The Workbook Object in Visual Basic for Applications (VBA)

The Worksheet Object in Visual Basic for Applications (VBA)

The Range and Cells Object in Visual Basic for Applications (VBA)

Preview 08:36

Worksheet properties in Visual Basic for Applications (VBA)

Worksheet events and methods in Visual Basic for Applications (VBA)

Worksheet properties and events
03:28

Workbook properties in Visual Basic for Applications (VBA)

Workbook events and methods in Visual Basic for Applications (VBA)

Preview 05:02

The Cells objects and their properties in Visual Basic for Applications (VBA)

The Range objects and their properties in Visual Basic for Applications (VBA)

How to refer to Excel cells in Visual Basic for Applications (VBA)

How to define a range in Excel and refer to in Visual Basic for Applications (VBA)

Cells and Ranges as objects, VBA object in Excel sheets
11:35

How to add VBA controls in an Excel worksheet

How to assign events to VBA controls in an Excel Worksheet

Assign events to objects in Excel sheets
05:35

Verify your knowledge in Object Oriented Programming and check if you can distinguish the objects in Excel

Objects in VBA and Excel
8 questions
+
Ranges and cells
14 Lectures 51:55

Overview of the Range Object in Visual Basic for Applications (VBA)

How to refer to a range by address in Visual Basic for Applications (VBA)

How to refer to a range by rows and columns in Visual Basic for Applications (VBA)


The Range Object
08:46

The properties of the Range object in Visual Basic for Applications (VBA)

The special range object: the Selection object in Visual Basic for Applications (VBA)

The properties, methods and events of the Selection object in Visual Basic for Applications (VBA)

How to refer to ranges in other worksheets in Visual Basic for Applications (VBA)

Range properties and selection tips, Refer to Ranges in other sheets
02:31

How to refer to elements/cellswithin a range by means of rows and columns in Visual Basic for Applications (VBA)

The Offset property of ranges in Visual Basic for Applications (VBA)

How to use the Offset property to get an element in an Excel range in Visual Basic for Applications (VBA)

The Offset property, Columns and Rows to refer to Ranges
00:51

How to retrieve the address of a range object in Visual Basic for Applications (VBA)

How to set the size of a range object in Visual Basic for Applications (VBA)

How to select a range with Visual Basic for Applications (VBA)

Retrieve the address in ranges, Size and resize ranges
01:04

How to refer to a range or element of a range by row and column in Visual Basic for Applications (VBA)

How to join ranges in Visual Basic for Applications (VBA)

Columns and Rows to refer to Ranges, Join multiple ranges
01:26

How to merge ranges in Visual Basic for Applications (VBA)

How to select ranges in Visual Basic for Applications (VBA)

Merge ranges, select ranges
01:21

How to intersect ranges in Visual Basic for Applications (VBA)

Intersect ranges
01:37

How to verify if an object is empty in Visual Basic for Applications (VBA)

IsEmpy function
00:53

The CurrentRegion property in Visual Basic for Applications (VBA)

How to retrieve the current region of an object or range in Visual Basic for Applications (VBA)

CurrentRegion property
01:00

The Area Collection properties in Visual Basic for Applications (VBA)

Areas Collection properties
01:41

How to evaluate the position of elements in an Excel worksheet using the range properties in Visual Basic for Applications (VBA)

The End property of an Excel range in Visual Basic for Applications (VBA)

The parameters of the End property of an Excel range in Visual Basic for Applications (VBA)

Evaluate positions in Excel sheets with the range properties (End, Row, Column)
00:35

identify ranges and cells in the object hierarchy, the value property, define a range with the "set" instruction

identify ranges and cells in the object hierarchy, the value property
02:03

How to create a macro to automatically format a range in Visual Basic for Applications (VBA)

How to add borders and colors to a range in Excel using Visual Basic for Applications (VBA)

Format ranges – create an automatic routine
15:19

Special cells in Excel with Visual Basic for Applications (VBA)

The SpecialCells method of Excel ranges in Visual Basic for Applications (VBA)

How to refer to cells of specified types and values in Visual Basic for Applications (VBA)

How to select the cells containing data in Excel using Visual Basic for Applications (VBA)

Special cells
12:48

Cells and Ranges
6 questions
+
VBA Dialogs
6 Lectures 17:42

How to show messages in Visual Basic for Applications (VBA)

The Msgbox Dialog and object in Visual Basic for Applications (VBA)

The Msgbox object, Msgbox properties, Predefined Dialogs
04:36

How to manage the standard Excel Dialog forms in Visual Basic for Applications (VBA)

How to customize an Excel dialog box in Visual Basic for Applications (VBA)

Standard Excel Dialogs, Customize a dialog box
04:33

The parameters and constants to use to customize the dialog boxes in Excel using Visual Basic for Applications (VBA)

VBA constants, VBA constants for dialogs
03:20

How to customize query dialog boxes in Excel using Visual Basic for Applications (VBA)

The SaveAs queries in an Excel Message Dialog box in Visual Basic for Applications (VBA)

How to customize messages and the behavior of the message boxes in Excel using Visual Basic for Applications (VBA)

Combine VBA constants for complex statements in dialogs
01:16

How to input data in Excel using the InputBox in Visual Basic for Applications (VBA)

How to customize data entry in Visual Basic for Applications (VBA)

The InputBox
02:04

The VBA Constants in Visual Basic for Applications (VBA)

How to find the VBA constants in Visual Basic for Applications (VBA)

How to find VBA constants and their references
01:53

You will check your knowledge about customizing dialog boxes in VBA

Dialog Boxes in VBA
3 questions
+
Special functions
2 Lectures 19:08

How to manage and customize Excel functions using Visual Basic for Applications (VBA)

Manage Excel User-Defined functions with Visual Basic for Applications (VBA)

User-defined functions, Excel functions in VBA functions
07:04

How to customize complex and combined Excel functions using Visual Basic for Applications (VBA)

Custom Excel functions, complex functions
12:04
+
Loops
3 Lectures 13:01

Understand the For..Next Loop in Visual Basic for Applications (VBA)

For..Next Loops
02:21

The Do,Do..While,Do..Until,While..Wend Loops in Visual Basic for Applications (VBA)

Do Loops, While..Wend loops, Do While Loops, Do Until Loops
03:01

Special Loops in Visual Basic for Applications (VBA): the for each loop, the loop for objects

How to refer to elements of object arrays in Visual Basic for Applications (VBA)

For Each – The VBA loop: loop in objects
07:39

Loops in VBA
2 questions
+
Operations and logical instructions
5 Lectures 12:14

Operators in Visual Basic for Applications (VBA)

Create Math functions in Visual Basic for Applications (VBA)

Logical Operators in Visual Basic for Applications (VBA)

The MOD Instruction in Visual Basic for Applications (VBA)

Operators, The MOD instruction, The logical instructions
06:39

Conditional instructions in Visual Basic for Applications (VBA)

The IF condition in Visual Basic for Applications (VBA)

IF..Then..Else...ElseIf in Visual Basic for Applications (VBA)

The IF instruction, IF, ELSE, ELSEIF…
01:49

The With Instruction in Visual Basic for Applications (VBA)

With instruction
01:23

How to interrupt the execution of a macro in Visual Basic for Applications (VBA)

Instruction to interrupt the execution of the code
00:59

The select case instruction in Visual Basic for Applications (VBA). An alternative to the If instruction

Select case instruction
01:24

You will verify your knowledge of conditional instructions inVBA

Conditional Instructions
4 questions
42 More Sections
About the Instructor
Daniele Protti
3.6 Average rating
263 Reviews
7,609 Students
14 Courses
Project Manager and Software Architect

I have 20+ years experience in IT project management, software development and software architecture.

I have led several teams of software developers as project manager, quality manager and as team leader in different companies and different countries in sectors e.g. telecommunication, research & development, travel business, Internet marketing and Internet business, consultancy and services.

I have been responsible to collect the requirements of projects, applications and processes, design the databases and specify the final objects.

During my career I have accumulated a lot of experiences dealing with processes of any kind and the need to define the tools to manage them and collect the information.

Most of my tools have been written in VB, VBA, C++, C#, Java, PHP, Javascript using databases e.g. Informix, Postgres, Oracle and MySql.

I have organized all my experiences in courses which are not only a list of functions and methods but contain also my practical experiences and considerations about how to cope with the different situations and which solutions to suggest.