Video description
Welcome to Excel VBA Programming–The Complete Guide, the most comprehensive VBA course! Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications such as 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 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
- Workbooks and workbook objects
- Worksheets and worksheet objects
- Range references
- Range actions
- Conditional logic
- Iteration
- Alerts
- Configuring Excel functionality
- Custom functions
- Arrays
- Debugging, even procedures, and user forms
No programming experience is required; complete beginners are more than welcome! VBA is a great language to start with because it lets you 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 redundancy in your workflows and accelerates your productivity drastically! Thanks for checking out this course!
What You Will Learn
- Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
- Utilize objects in the Excel Object Model to emulate user actions in Excel
- React dynamically to user events such as entering a cell value or opening a workbook
- Get comfortable with the fundamentals of computer programming
Audience
This course is for spreadsheet users who want to automate their daily workflow and business analysts who want to remove redundancy from their common tasks. Excel users who are curious about exploring programming in a familiar work environment will also benefit from the course.
About The Author
Boris Paskhaver: Boris Paskhaver is a NYC-based web developer and software engineer with experience in building apps in React/Redux and Ruby on Rails. Raised in New Jersey, he graduated from the Stern School of Business at New York University in 2013 with a double major in business economics and marketing. Since graduation, his work has taken him in a wide variety of directions—he spent years in marketing, then financial services, and now the tech industry.
He has worked everywhere, from a 50-person digital agency to an international tech powerhouse with thousands of employees. He always had a love of learning but struggled with the traditional resources available for education. His goal is to create comprehensive courses that break down complex details into small, digestible pieces.
Table of contents
- Chapter 1 : Getting Started
- Chapter 2 : The Fundamentals of the Excel Object Model
- Chapter 3 : The Visual Basic Editor
- Chapter 4 : Objects and Methods
-
Chapter 5 : Variables and Data Types
- Syntax Tips
- Variable Declarations and Assignments
- Multiple Variable Declarations
- The Option Explicit Setting
- The Byte, Integer and Long Data Types
- Mathematical Operations
- The Single and Double Data Types
- The String Data Type
- The Boolean Data Type
- The Date Data Type
- The Variant Data Type
- The Object Data Type
- Default Values for Declared Variables
- Chapter 6 : Procedures
-
Chapter 7 : Object Deep Dive
- The Application Object
- The Application.DisplayAlerts Property
- The Workbooks.Count and Worksheets.Count Properties
- The Workbooks.Open Method and Workbook.Path Property
- The Workbooks.Close Method
- The Workbooks.Add Method
- The Workbook.SaveAs and Workbook.Save Methods
- The Workbook.Activate Method
- The Workbook.Close Method
- The Worksheets.Add Method
- The Worksheet.Visible Property
- The Worksheet.Copy Method
- The Worksheet.Delete Method
- The Worksheet.Move Method
-
Chapter 8 : Range References
- The Range.Select Method
- The Value vs. Text Properties
- R1C1 Notation, Part I
- R1C1 Notation, Part II
- The Formula and FormulaR1C1 Properties
- The Range.Offset Property
- The Range.Resize Property
- The Cells Property
- The Range.CurrentRegion Property
- The Range.End Property
- The Range.Count and Range.CountLarge Properties
- The Range.Row and Range.Column Properties
- The Range.Rows and Range.Columns Properties
- The Range.EntireRow and Range.EntireColumn Properties
- Get Last Row of Data in Worksheet
-
Chapter 9 : Range Actions
- The Range.FillDown Method
- The Range.Replace Method
- The Range.TextToColumns Method
- The Range.Worksheet Property
- The Range.Sort Method
- The Range.Font Property
- The Range.Interior Property
- The Range.ColumnWidth and Range.RowHeight Properties
- The Range.AutoFit Method
- The Range.Clear, Range.ClearContents and Range.ClearFormats Methods
- The Range.Delete Method
- The Range.Copy and Range.Cut Methods
- The Paste and PasteSpecial Methods on the Worksheet Object
- The Parent Property on All Objects
- Chapter 10 : Conditionals
- Chapter 11 : Iteration
- Chapter 12 : Miscellaneous Features
- Chapter 13 : Arrays
- Chapter 14 : Functions
- Chapter 15 : Debugging
- Chapter 16 : Events
-
Chapter 17 : User Forms
- Create UserForm, Toolbox, Properties, Controls
- The Label and TextBox Controls
- Naming Conventions
- Design Aesthetics
- The CommandButton Control
- Add Event Procedure to Control
- Unload and Hide a UserForm
- Submit the UserForm
- Activate a UserForm from Procedure
- The initialize Event
- The ListBox Control I - Wire up the Form
- The ListBox Control II - React to User Selection
- The ListBox Control III - Select Multiple Items
- The ComboBox Control I
- The ComboBox Control II
- The CheckBox Control
Product information
- Title: Excel VBA Programming - The Complete Guide
- Author(s):
- Release date: August 2019
- Publisher(s): Packt Publishing
- ISBN: 9781839214240
You might also like
book
Excel VBA Programming For Dummies, 6th Edition
Find out what Excel is capable of with this step-by-step guide to VBA Short of changing …
video
Microsoft Excel 2021/365 - Beginner to Advanced
Microsoft has released its latest stand-alone Excel version, which opens up many of the features and …
video
The Complete Excel Guide: Beginners to Advanced
Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential …
book
Excel 2019 Power Programming with VBA
Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to …