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.8 (72 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,704 students enrolled
Instructed by Daniele Protti IT & Software / Other
$19
$100
81% off
Take This Course
  • Lectures 263
  • Length 33 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course 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.

What are the requirements?

  • Microsoft Excel
  • Microsoft Word

What am I going to get from this course?

  • 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

What is the target audience?

  • software developers
  • accounters
  • employees in HR, Finance, Accounting
  • Business Analysts
  • Business Intelligent developers
  • Project manager
  • Quality managers

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
04:17

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

11:53

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

Section 2: Overview of VBA and of the tool
12:02

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

03:00

Overview of Excel version 2013

Macro Security
07:26
07:53

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

10:12

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

07:28

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


06:23

Overview of the VBE in the version 2013

04:04

Overview of the Developer Ribbon in Excel version 2013

Section 3: The VBA language
07:57

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

10:15

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)

Section 4: Functions, subroutines, constants and variables
07:08

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)

06:35

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)

1 question

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

07:40

Type of variables in Visual Basic for Applications (VBA)

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

4 questions

What is the difference between variables and constants

03:32

Function declarations in Visual Basic for Applications (VBA)

01:34

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

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

02:22

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)

01:16

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)

1 question

Verify your knowledge about the size of a variable set

Section 5: Objects
08:36

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)

03:28

Worksheet properties in Visual Basic for Applications (VBA)

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

05:02

Workbook properties in Visual Basic for Applications (VBA)

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

11:35

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)

05:35

How to add VBA controls in an Excel worksheet

How to assign events to VBA controls in an Excel Worksheet

8 questions

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

Section 6: Ranges and cells
08:46

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)


02:31

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)

00:51
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)

01:04

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)

01:26

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)

01:21

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

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

01:37

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

00:53

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

01:00

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)

01:41

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

00:35

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)

02:03

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

15:19

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)

12:48

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)

Cells and Ranges
6 questions
Section 7: VBA Dialogs
04:36

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

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

04:33

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)

03:20

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

01:16

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)

02:04

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)

01:53

The VBA Constants in Visual Basic for Applications (VBA)

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

3 questions

You will check your knowledge about customizing dialog boxes in VBA

Section 8: Special functions
07:04

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

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

12:04

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

Section 9: Loops
02:21

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

03:01

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

07:39

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)

Loops in VBA
2 questions
Section 10: Operations and logical instructions
06:39

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)

01:49

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)

01:23

The With Instruction in Visual Basic for Applications (VBA)

00:59

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

01:24

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

4 questions

You will verify your knowledge of conditional instructions inVBA

Section 11: Formulas in ranges and Excel objects
10:03

How to customize Excel formulas for ranges and cells with Visual Basic for Applications (VBA)

02:16

How to get ranges in Excel worksheets using Visual Basic for Applications (VBA)

03:15

How to implement the Excel Conditional Formatting instruction with Visual Basic for Applications (VBA)

08:16

How to get information about Excel ranges in Visual Basic for Applications (VBA) based on the properties of the range object

4 questions

You will verify your knowledge about how to manage and customize Excel fomulas with VBA

Section 12: Object events and properties
07:21

Understand the events and methods for Excel worksheets and workbooks and customize them in Visual Basic for Applications (VBA)

09:52

The events of the Workbook object in Visual Basic for Applications (VBA)

07:15

How to customize an Excel Chart by manipulating the Chart object in Visual Basic for Applications (VBA)

07:16

Understand the default events of the Excel worksheet object in Visual Basic for Applications (VBA)

01:13

Understand the default events of Excel objects

Understand the properties of Excel objects

Manipulate events and properties of Excel object with Visual Basic for Applications (VBA)

04:46

What is the Application object in Visual Basic for Applications (VBA)

The properties and events of the Application objects in Visual Basic for Applications (VBA)

2 questions

You will verify your knowledge about the default properties and events of the main Excel objects: Workbook, Worksheet, Chart and the Application object

Section 13: Forms
10:52

What is a User Form in Visual Basic for Applications (VBA)

How to create a form in Visual Basic for Applications (VBA)


04:07

Edit a User Form in Visual Basic for Applications (VBA) as a content of controls

Understand the code behind a User Form in Visual Basic for Applications (VBA)

How to add controls to a User Form in Visual Basic for Applications (VBA)

01:42

How to customize and create events of User Forms in Visual Basic for Applications (VBA)

How to refer to subroutines and functions of modules in User Forms in Visual Basic for Applications (VBA)

05:45

How to add, position and configure controls in a User From in Visual Basic for Applications (VBA)

How to customize the design of a User Form in Visual Basic for Applications (VBA)

04:37

How to add events of controls in a User Form in Visual Basic for Applications (VBA)

How to make the controls in a User Form interact

How to trigger actions on controls by executing events on other objects in a User Form in Visual Basic for Applications (VBA)

11:19

Example of a User Form with controls which interact in Visual Basic for Applications (VBA)

11:40

Example of User Form in Visual Basic for Applications (VBA)

06:08

The Tab objects in a User Form in Visual Basic for Applications (VBA)

06:27

How to make more User Form interact in Visual Basic for Applications (VBA)

01:59

How controls in a User Form can influence objects in other User Forms in Visual Basic for Applications (VBA)

An example with the Calendar object and the interaction with other controls

05:13

How to format a tab in a User Form in Visual Basic for Applications (VBA)

04:11

The Richtext object in User Forms in Visual Basic for Applications (VBA)

How to show and hide User Forms in Visual Basic for Applications (VBA)

01:43

How to add images and format the layout of User Froms in Visual Basic for Applications (VBA)

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Daniele Protti, 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.

Ready to start learning?
Take This Course