Excel VBA Programming - The Complete Guide

4.7 (3297)
MOOC
Payment
Learning paid
Language
English
Duration
18 hours course
Course by Udemy
What will you learn?
Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
Utilize the objects in the Excel Object Model to emulate user actions in Excel
React dynamically to user events like entering a cell value or opening a workbook
Feel comfortable with the fundamentals of computer programming
About the course

Welcome to Excel VBA Programming - The Complete Guide, Udemy's most comprehensive VBA course!

Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA!

Over the course of more than 18 hours of content, we'll cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including:

  • The Excel Object Model
  • The Visual Basic Editor
  • Objects and Methods
  • Variables and Data Types
  • Writing Your Own Procedures
  • The Workbooks and Workbook Objects
  • The Worksheets and Worksheet Objects
  • Range References
  • Range Actions
  • Conditional Logic
  • Iteration
  • Alerts
  • Configuring Excel Functionality
  • Custom Functions
  • Arrays
  • Debugging
  • Even Procedures
  • User Forms

In addition to the video content, the course is packed with dozens of quizzes, challenges, and assignments to test your knowledge of your material as you progress.

No programming experience is required complete beginners are more than welcome! VBA is a great language to start with because you can master the fundamentals of programming in a familiar work environment.

No extra software is necessary - VBA is bundled with all modern versions of Excel.

Excel is the world's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove the redundancy in your workflow and accelerate your productivity drastically!

Thanks for checking out the course!

Program
Getting Started
Setup the VBA development environment, configure our security settings, test out the built-in macro recorder, and more!
Introduction
In this lesson, we introduce VisualBasic for Applications (VBA), a powerful language for automating operations in Microsoft Office applications. We discuss:
  • the benefits offered by the technology
  • the tools and features available inVBA
  • a brief history of the languageincluding its precursors Basic and VisualBasic
  • the prerequisites for the course
Download Course Materials
This lesson contains all the Excel worksheets used during the recording of the course.Although it's a good idea to reference the material, the best strategy is to code alongside the videos to practice these concepts yourself.
Enable the Developer Tab
The Developer Tab is a secret Tab on theRibbon that includes several options for working withVBA. Users can access the VisualBasic Editor, enable theMacroRecorder, and display a list of public macros. In this lesson, we expose the Developer Tab and introduce some of itsavailable commands.
Excel File Types
There are dozens of file types available inExcel.In order to work with macros, weneed to save our files in a special format called.xlsm. In this lesson, weintroduce an option for defaulting to a.xlsm format upon saving.
Macro Security
Macros have been used to package malicious code in the past. In this lesson, weexplore the security options built intoExcel that prevent macro code from executing automatically.Wealso add a directory to aTrusted Locations list of folders to mark the files in it as safe to run.
The Macro Recorder
The MacroRecorder is a powerful tool that converts your interface actions (i.e. clicks, navigations, aesthetic changes) into validVBAcode. In this lesson, wediscuss the merits (and drawbacks) of the MacroRecorder and explore some of the code that it generates.
Record Macro to Change Worksheet Orientation
Absolute vs. Relative References I
The Macro Recorder can record withabsolute orrelative references.Absolute references (the default recording option)target specific cells (i.e. B1) the recorder is more concerned with the final destination.Relative references record changes relative to a cell the recorder is more concerned with the steps of travel from a starting position.In this lesson, we record one macro with each type of reference and compare the generated code in the VisualBasic Editor.
Absolute vs. Relative References II
In this lesson, we continue our exploration ofabsolute vsrelative references by recording a macro that deletes a row from the worksheet. Absolute references explicitly target a specific row each time, which defeats the purpose of the macro. Relative references allow us to fix this bug.
The Visual Basic Editor
In this lesson, we explore the components of the VisualBasic Editor, including the
  • Project Explorer, which lists all openworkbooks and worksheets as well as all modules (containers for code).
  • PropertiesWindow, which can be used to get or set properties on objects withExcel.An object represents an entityin the program (i.e. aWorkbook, Worksheet, module, etc.)
  • ImmediateWindow, a playground for executing single lines of VBAcode
  • CodeEditor, where the developer writes the actual macro code
VBA Basics
Test your knowledge of the basics of VBA including file types, macro security, the macro recorder, absolute and relative references, and more!
Requirements
  • A modern version of Microsoft Excel for Windows (2016 is strongly recommended)
  • Intermediate knowledge of popular Excel features (functions, PivotTables, charts, etc.)
  • Basic knowledge of data types (numbers, strings, Booleans, dates)
  • A desire to learn!
Lecturers
Boris Paskhaver
Boris Paskhaver
Software Engineer | Consultant | Author
Platform
/storage/img/providers/udemy.svg
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Rating
4.7
(1669)
(1310)
(299)
(40)
(20)
Comments (3297)
Like any other website, konevy uses «cookies». These cookies are used to store information including visitor's preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information. For more general information on cookies, please read the «What Are Cookies» article on Cookie Consent website.