Excel VBA Programming - The Complete Guide

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

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!

Who this course is for:

  • Spreadsheet users who want to automate their daily workflow
  • Business analysts who want to remove redundancy from their common tasks
  • Excel users who are curious about exploring programming in a familiar work environment

Expected Outcomes

  1. 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 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! Description 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! Who this course is for: Spreadsheet users who want to automate their daily workflow Business analysts who want to remove redundancy from their common tasks Excel users who are curious about exploring programming in a familiar work environment Show more Show less Featured review Marco Antonio Garza Gómez 8 courses 4 reviews Rating: 5.0 out of 5 a year ago It's really well explain, the teacher puts attention to every detail, so you dont have any doubts along the sections, and you really feel confident when doing the assignments cause it's easy to understand the VBA logic. Show more Show less Course content 18 sections • 159 lectures • 17h 58m total length Expand all sections Getting Started 10 lectures • 1hr 15min Introduction Preview 13:08 About Me 00:56 Download Course Materials 00:42 Enable the Developer Tab Preview 07:06 Excel File Types 04:00 Macro Security 08:43 The Macro Recorder 15:12 Record Macro to Change Worksheet Orientation 2 questions Absolute vs. Relative References I 08:12 Absolute vs. Relative References II 08:14 The Visual Basic Editor 09:01 VBA Basics 7 questions The Fundamentals of the Excel Object Model 7 lectures • 52min Object-Oriented Programming in Real Life Preview 11:29 Real Life Objects 3 questions Collection Objects in Real Life 05:50 Objects As Properties 09:08 The Excel Object Model 13:34 Access Object from Collection by Name 03:57 Default Properties 03:38 The Name Property on Workbook and Worksheet Objects 04:03 Object-Oriented Programming 6 questions The Visual Basic Editor 5 lectures • 50min Visual Basic Editor Options 13:39 Create and Delete a Procedure Preview 08:51 Procedures 5 questions The Immediate Window and Debug.Print Method 08:45 The MsgBox Method 13:34 Comments 05:18 Practice with Procedures 6 questions The Visual Basic Editor 11 questions Objects and Methods 6 lectures • 38min Methods without Arguments 03:28 Methods without Arguments 3 questions Methods with Arguments 08:30 Methods with Arguments 3 questions Methods with Multiple Arguments 06:42 The Object Browser 05:28 Ways to Invoke A Procedure 08:17 The TypeName Method 05:53 Objects and Methods 9 questions Variables and Data Types 13 lectures • 1hr 20min Syntax Tips 07:37 Variable Declarations and Assignments 10:01 Multiple Variable Declarations 04:14 The Option Explicit Setting 05:52 The Byte, Integer and Long Data Types 07:54 Numeric Data Types 3 questions Mathematical Operations 06:06 The Single and Double Data Types 05:59 The String Data Type 04:58 String and Double Data Types 5 questions The Boolean Data Type 04:24 The Date Data Type 06:22 The Variant Data Type 05:42 The Object Data Type 08:04 Default Values for Declared Variables 02:53 Variable Declarations 2 questions Procedures 7 lectures • 47min Variable Scope 09:30 Call A Procedure from Another one 03:54 Procedures with Arguments 07:15 Procedure Scope (Public vs. Private) 06:54 The Exit Sub Keywords 01:49 Constants 06:48 Predefined Constants Preview 11:00 Procedures 6 questions Object Deep Dive 14 lectures • 1hr 8min The Application Object 04:14 The Application.DisplayAlerts Property 06:26 The Workbooks.Count and Worksheets.Count Properties 02:07 The Workbooks.Open Method and Workbook.Path Property 06:59 The Workbooks.Close Method 01:47 The Workbooks.Add Method 05:56 The Workbook.SaveAs and Workbook.Save Methods 09:31 The Workbook.Activate Method 06:58 The Workbook.Close Method 04:13 The Application, Workbooks and Workbook Objects 6 questions The Worksheets.Add Method 05:27 Add a New Worksheet to End of Current List of Worksheets 1 question The Worksheet.Visible Property 05:11 The Worksheet.Copy Method 03:34 The Worksheet.Delete Method 02:24 The Worksheet.Move Method 02:58 Range References 15 lectures • 1hr 26min The Range.Select Method Preview 08:42 The Value vs. Text Properties 03:50 R1C1 Notation, Part I 09:53 R1C1 Notation, Part II 07:55 The Formula and FormulaR1C1 Properties 06:47 The Range.Offset Property 05:05 The Range.Resize Property 03:53 The Offset and Resize Properties 10 questions The Cells Property 04:43 The Range.CurrentRegion Property 05:00 The Range.End Property 08:24 The Range.Count and Range.CountLarge Properties 03:20 The Range.Row and Range.Column Properties 02:25 The Range.Rows and Range.Columns Properties 06:59 The Range.EntireRow and Range.EntireColumn Properties 02:54 Get Last Row of Data in Worksheet 06:23 Range Actions 14 lectures • 1hr 22min The Range.FillDown Method 05:01 The Range.Replace Method 04:42 The Range.TextToColumns Method 09:28 The Range.Worksheet Property 02:09 The Range.Sort Method 12:32 The Range.Font Property 09:07 The Range.Interior Property 06:41 The Range.ColumnWidth and Range.RowHeight Properties 06:27 The Range.AutoFit Method 02:58 The Range.Clear, Range.ClearContents and Range.ClearFormats Methods 04:02 The Range.Delete Method 05:53 The Range.Copy and Range.Cut Methods 04:00 The Paste and PasteSpecial Methods on the Worksheet Object 04:56 The Parent Property on All Objects 04:23 Conditionals 6 lectures • 46min Boolean Expressions 06:27 Boolean Expressions 9 questions The If Then Statement 04:05 The ElseIf and Else Statements 10:41 Select Case 10:41 The AND & OR Logical Operators 06:34 Logical Operators 14 questions The NOT Operator 07:27 8 more sections Instructor Boris Paskhaver Software Engineer | Consultant | Author 4.7 Instructor Rating 26,865 Reviews 303,386 Students 6 Courses Hi there, it's nice to meet you! I'm a New York City-based software engineer, author, and consultant who's been teaching on Udemy since 2016 . Like many of my peers, I did not follow a conventional approach to my current role as a web developer. After graduating from New York University in 2013 with a degree in Business Economics and Marketing, I worked as a business analyst, systems administrator, and data analyst for a variety of companies including a digital marketing agency, a financial services firm, and an international tech powerhouse. At one of those roles, I was fortunate enough to be challenged to build several projects with Python and JavaScript. There was no formal computer science education for me; I discovered coding entirely by accident. A small work interest quickly blossomed into a passionate weekend hobby. Eventually, I left my former role to complete App Academy, a rigorous full-stack web development bootcamp in NYC. The rest is history. I've always been fascinated by the intersection of technology and education, especially since I've struggled with many of the traditional resources people use to learn how to program. My goal as an instructor is to create comprehensive step-by-step courses that break down the complex details into small, digestible pieces. I like to build the kind of material that I myself would have loved to have when I was starting out . I'm passionate about teaching and would love to help you discover what code can do for you . See you in a course soon! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fcb56f4e4089',m:'212ab94c143cb026ba23a655a788a33ee6225cab-1627841048-1800-AfCHi8/BfmUZuDQxSrKsxTIYGrw802LvDBPT9YBC/pExOhKG2Ajz3ez565z7tMHHu/J9/KgncMplUuQH7gF4lsboCiqEsMzbhjlV7qKZXphq8JHMdwDSxJIL7acazBQQYhBNGkyJaxI9rHNn7cPqCTc=',s:[0xba2793dee7,0x2b7910be9f],}})();
  2. 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 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! Description 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! Who this course is for: Spreadsheet users who want to automate their daily workflow Business analysts who want to remove redundancy from their common tasks Excel users who are curious about exploring programming in a familiar work environment Show more Show less Featured review Marco Antonio Garza Gómez 8 courses 4 reviews Rating: 5.0 out of 5 a year ago It's really well explain, the teacher puts attention to every detail, so you dont have any doubts along the sections, and you really feel confident when doing the assignments cause it's easy to understand the VBA logic. Show more Show less Course content 18 sections • 159 lectures • 17h 58m total length Expand all sections Getting Started 10 lectures • 1hr 15min Introduction Preview 13:08 About Me 00:56 Download Course Materials 00:42 Enable the Developer Tab Preview 07:06 Excel File Types 04:00 Macro Security 08:43 The Macro Recorder 15:12 Record Macro to Change Worksheet Orientation 2 questions Absolute vs. Relative References I 08:12 Absolute vs. Relative References II 08:14 The Visual Basic Editor 09:01 VBA Basics 7 questions The Fundamentals of the Excel Object Model 7 lectures • 52min Object-Oriented Programming in Real Life Preview 11:29 Real Life Objects 3 questions Collection Objects in Real Life 05:50 Objects As Properties 09:08 The Excel Object Model 13:34 Access Object from Collection by Name 03:57 Default Properties 03:38 The Name Property on Workbook and Worksheet Objects 04:03 Object-Oriented Programming 6 questions The Visual Basic Editor 5 lectures • 50min Visual Basic Editor Options 13:39 Create and Delete a Procedure Preview 08:51 Procedures 5 questions The Immediate Window and Debug.Print Method 08:45 The MsgBox Method 13:34 Comments 05:18 Practice with Procedures 6 questions The Visual Basic Editor 11 questions Objects and Methods 6 lectures • 38min Methods without Arguments 03:28 Methods without Arguments 3 questions Methods with Arguments 08:30 Methods with Arguments 3 questions Methods with Multiple Arguments 06:42 The Object Browser 05:28 Ways to Invoke A Procedure 08:17 The TypeName Method 05:53 Objects and Methods 9 questions Variables and Data Types 13 lectures • 1hr 20min Syntax Tips 07:37 Variable Declarations and Assignments 10:01 Multiple Variable Declarations 04:14 The Option Explicit Setting 05:52 The Byte, Integer and Long Data Types 07:54 Numeric Data Types 3 questions Mathematical Operations 06:06 The Single and Double Data Types 05:59 The String Data Type 04:58 String and Double Data Types 5 questions The Boolean Data Type 04:24 The Date Data Type 06:22 The Variant Data Type 05:42 The Object Data Type 08:04 Default Values for Declared Variables 02:53 Variable Declarations 2 questions Procedures 7 lectures • 47min Variable Scope 09:30 Call A Procedure from Another one 03:54 Procedures with Arguments 07:15 Procedure Scope (Public vs. Private) 06:54 The Exit Sub Keywords 01:49 Constants 06:48 Predefined Constants Preview 11:00 Procedures 6 questions Object Deep Dive 14 lectures • 1hr 8min The Application Object 04:14 The Application.DisplayAlerts Property 06:26 The Workbooks.Count and Worksheets.Count Properties 02:07 The Workbooks.Open Method and Workbook.Path Property 06:59 The Workbooks.Close Method 01:47 The Workbooks.Add Method 05:56 The Workbook.SaveAs and Workbook.Save Methods 09:31 The Workbook.Activate Method 06:58 The Workbook.Close Method 04:13 The Application, Workbooks and Workbook Objects 6 questions The Worksheets.Add Method 05:27 Add a New Worksheet to End of Current List of Worksheets 1 question The Worksheet.Visible Property 05:11 The Worksheet.Copy Method 03:34 The Worksheet.Delete Method 02:24 The Worksheet.Move Method 02:58 Range References 15 lectures • 1hr 26min The Range.Select Method Preview 08:42 The Value vs. Text Properties 03:50 R1C1 Notation, Part I 09:53 R1C1 Notation, Part II 07:55 The Formula and FormulaR1C1 Properties 06:47 The Range.Offset Property 05:05 The Range.Resize Property 03:53 The Offset and Resize Properties 10 questions The Cells Property 04:43 The Range.CurrentRegion Property 05:00 The Range.End Property 08:24 The Range.Count and Range.CountLarge Properties 03:20 The Range.Row and Range.Column Properties 02:25 The Range.Rows and Range.Columns Properties 06:59 The Range.EntireRow and Range.EntireColumn Properties 02:54 Get Last Row of Data in Worksheet 06:23 Range Actions 14 lectures • 1hr 22min The Range.FillDown Method 05:01 The Range.Replace Method 04:42 The Range.TextToColumns Method 09:28 The Range.Worksheet Property 02:09 The Range.Sort Method 12:32 The Range.Font Property 09:07 The Range.Interior Property 06:41 The Range.ColumnWidth and Range.RowHeight Properties 06:27 The Range.AutoFit Method 02:58 The Range.Clear, Range.ClearContents and Range.ClearFormats Methods 04:02 The Range.Delete Method 05:53 The Range.Copy and Range.Cut Methods 04:00 The Paste and PasteSpecial Methods on the Worksheet Object 04:56 The Parent Property on All Objects 04:23 Conditionals 6 lectures • 46min Boolean Expressions 06:27 Boolean Expressions 9 questions The If Then Statement 04:05 The ElseIf and Else Statements 10:41 Select Case 10:41 The AND & OR Logical Operators 06:34 Logical Operators 14 questions The NOT Operator 07:27 8 more sections Instructor Boris Paskhaver Software Engineer | Consultant | Author 4.7 Instructor Rating 26,865 Reviews 303,386 Students 6 Courses Hi there, it's nice to meet you! I'm a New York City-based software engineer, author, and consultant who's been teaching on Udemy since 2016 . Like many of my peers, I did not follow a conventional approach to my current role as a web developer. After graduating from New York University in 2013 with a degree in Business Economics and Marketing, I worked as a business analyst, systems administrator, and data analyst for a variety of companies including a digital marketing agency, a financial services firm, and an international tech powerhouse. At one of those roles, I was fortunate enough to be challenged to build several projects with Python and JavaScript. There was no formal computer science education for me; I discovered coding entirely by accident. A small work interest quickly blossomed into a passionate weekend hobby. Eventually, I left my former role to complete App Academy, a rigorous full-stack web development bootcamp in NYC. The rest is history. I've always been fascinated by the intersection of technology and education, especially since I've struggled with many of the traditional resources people use to learn how to program. My goal as an instructor is to create comprehensive step-by-step courses that break down the complex details into small, digestible pieces. I like to build the kind of material that I myself would have loved to have when I was starting out . I'm passionate about teaching and would love to help you discover what code can do for you . See you in a course soon! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fcb56f4e4089',m:'212ab94c143cb026ba23a655a788a33ee6225cab-1627841048-1800-AfCHi8/BfmUZuDQxSrKsxTIYGrw802LvDBPT9YBC/pExOhKG2Ajz3ez565z7tMHHu/J9/KgncMplUuQH7gF4lsboCiqEsMzbhjlV7qKZXphq8JHMdwDSxJIL7acazBQQYhBNGkyJaxI9rHNn7cPqCTc=',s:[0xba2793dee7,0x2b7910be9f],}})();
  3. React dynamically to user events like entering a cell value or opening a workbook Feel comfortable with the fundamentals of computer programming 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! Description 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! Who this course is for: Spreadsheet users who want to automate their daily workflow Business analysts who want to remove redundancy from their common tasks Excel users who are curious about exploring programming in a familiar work environment Show more Show less Featured review Marco Antonio Garza Gómez 8 courses 4 reviews Rating: 5.0 out of 5 a year ago It's really well explain, the teacher puts attention to every detail, so you dont have any doubts along the sections, and you really feel confident when doing the assignments cause it's easy to understand the VBA logic. Show more Show less Course content 18 sections • 159 lectures • 17h 58m total length Expand all sections Getting Started 10 lectures • 1hr 15min Introduction Preview 13:08 About Me 00:56 Download Course Materials 00:42 Enable the Developer Tab Preview 07:06 Excel File Types 04:00 Macro Security 08:43 The Macro Recorder 15:12 Record Macro to Change Worksheet Orientation 2 questions Absolute vs. Relative References I 08:12 Absolute vs. Relative References II 08:14 The Visual Basic Editor 09:01 VBA Basics 7 questions The Fundamentals of the Excel Object Model 7 lectures • 52min Object-Oriented Programming in Real Life Preview 11:29 Real Life Objects 3 questions Collection Objects in Real Life 05:50 Objects As Properties 09:08 The Excel Object Model 13:34 Access Object from Collection by Name 03:57 Default Properties 03:38 The Name Property on Workbook and Worksheet Objects 04:03 Object-Oriented Programming 6 questions The Visual Basic Editor 5 lectures • 50min Visual Basic Editor Options 13:39 Create and Delete a Procedure Preview 08:51 Procedures 5 questions The Immediate Window and Debug.Print Method 08:45 The MsgBox Method 13:34 Comments 05:18 Practice with Procedures 6 questions The Visual Basic Editor 11 questions Objects and Methods 6 lectures • 38min Methods without Arguments 03:28 Methods without Arguments 3 questions Methods with Arguments 08:30 Methods with Arguments 3 questions Methods with Multiple Arguments 06:42 The Object Browser 05:28 Ways to Invoke A Procedure 08:17 The TypeName Method 05:53 Objects and Methods 9 questions Variables and Data Types 13 lectures • 1hr 20min Syntax Tips 07:37 Variable Declarations and Assignments 10:01 Multiple Variable Declarations 04:14 The Option Explicit Setting 05:52 The Byte, Integer and Long Data Types 07:54 Numeric Data Types 3 questions Mathematical Operations 06:06 The Single and Double Data Types 05:59 The String Data Type 04:58 String and Double Data Types 5 questions The Boolean Data Type 04:24 The Date Data Type 06:22 The Variant Data Type 05:42 The Object Data Type 08:04 Default Values for Declared Variables 02:53 Variable Declarations 2 questions Procedures 7 lectures • 47min Variable Scope 09:30 Call A Procedure from Another one 03:54 Procedures with Arguments 07:15 Procedure Scope (Public vs. Private) 06:54 The Exit Sub Keywords 01:49 Constants 06:48 Predefined Constants Preview 11:00 Procedures 6 questions Object Deep Dive 14 lectures • 1hr 8min The Application Object 04:14 The Application.DisplayAlerts Property 06:26 The Workbooks.Count and Worksheets.Count Properties 02:07 The Workbooks.Open Method and Workbook.Path Property 06:59 The Workbooks.Close Method 01:47 The Workbooks.Add Method 05:56 The Workbook.SaveAs and Workbook.Save Methods 09:31 The Workbook.Activate Method 06:58 The Workbook.Close Method 04:13 The Application, Workbooks and Workbook Objects 6 questions The Worksheets.Add Method 05:27 Add a New Worksheet to End of Current List of Worksheets 1 question The Worksheet.Visible Property 05:11 The Worksheet.Copy Method 03:34 The Worksheet.Delete Method 02:24 The Worksheet.Move Method 02:58 Range References 15 lectures • 1hr 26min The Range.Select Method Preview 08:42 The Value vs. Text Properties 03:50 R1C1 Notation, Part I 09:53 R1C1 Notation, Part II 07:55 The Formula and FormulaR1C1 Properties 06:47 The Range.Offset Property 05:05 The Range.Resize Property 03:53 The Offset and Resize Properties 10 questions The Cells Property 04:43 The Range.CurrentRegion Property 05:00 The Range.End Property 08:24 The Range.Count and Range.CountLarge Properties 03:20 The Range.Row and Range.Column Properties 02:25 The Range.Rows and Range.Columns Properties 06:59 The Range.EntireRow and Range.EntireColumn Properties 02:54 Get Last Row of Data in Worksheet 06:23 Range Actions 14 lectures • 1hr 22min The Range.FillDown Method 05:01 The Range.Replace Method 04:42 The Range.TextToColumns Method 09:28 The Range.Worksheet Property 02:09 The Range.Sort Method 12:32 The Range.Font Property 09:07 The Range.Interior Property 06:41 The Range.ColumnWidth and Range.RowHeight Properties 06:27 The Range.AutoFit Method 02:58 The Range.Clear, Range.ClearContents and Range.ClearFormats Methods 04:02 The Range.Delete Method 05:53 The Range.Copy and Range.Cut Methods 04:00 The Paste and PasteSpecial Methods on the Worksheet Object 04:56 The Parent Property on All Objects 04:23 Conditionals 6 lectures • 46min Boolean Expressions 06:27 Boolean Expressions 9 questions The If Then Statement 04:05 The ElseIf and Else Statements 10:41 Select Case 10:41 The AND & OR Logical Operators 06:34 Logical Operators 14 questions The NOT Operator 07:27 8 more sections Instructor Boris Paskhaver Software Engineer | Consultant | Author 4.7 Instructor Rating 26,865 Reviews 303,386 Students 6 Courses Hi there, it's nice to meet you! I'm a New York City-based software engineer, author, and consultant who's been teaching on Udemy since 2016 . Like many of my peers, I did not follow a conventional approach to my current role as a web developer. After graduating from New York University in 2013 with a degree in Business Economics and Marketing, I worked as a business analyst, systems administrator, and data analyst for a variety of companies including a digital marketing agency, a financial services firm, and an international tech powerhouse. At one of those roles, I was fortunate enough to be challenged to build several projects with Python and JavaScript. There was no formal computer science education for me; I discovered coding entirely by accident. A small work interest quickly blossomed into a passionate weekend hobby. Eventually, I left my former role to complete App Academy, a rigorous full-stack web development bootcamp in NYC. The rest is history. I've always been fascinated by the intersection of technology and education, especially since I've struggled with many of the traditional resources people use to learn how to program. My goal as an instructor is to create comprehensive step-by-step courses that break down the complex details into small, digestible pieces. I like to build the kind of material that I myself would have loved to have when I was starting out . I'm passionate about teaching and would love to help you discover what code can do for you . See you in a course soon! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fcb56f4e4089',m:'212ab94c143cb026ba23a655a788a33ee6225cab-1627841048-1800-AfCHi8/BfmUZuDQxSrKsxTIYGrw802LvDBPT9YBC/pExOhKG2Ajz3ez565z7tMHHu/J9/KgncMplUuQH7gF4lsboCiqEsMzbhjlV7qKZXphq8JHMdwDSxJIL7acazBQQYhBNGkyJaxI9rHNn7cPqCTc=',s:[0xba2793dee7,0x2b7910be9f],}})();
  4. Feel comfortable with the fundamentals of computer programming 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! Description 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! Who this course is for: Spreadsheet users who want to automate their daily workflow Business analysts who want to remove redundancy from their common tasks Excel users who are curious about exploring programming in a familiar work environment Show more Show less Featured review Marco Antonio Garza Gómez 8 courses 4 reviews Rating: 5.0 out of 5 a year ago It's really well explain, the teacher puts attention to every detail, so you dont have any doubts along the sections, and you really feel confident when doing the assignments cause it's easy to understand the VBA logic. Show more Show less Course content 18 sections • 159 lectures • 17h 58m total length Expand all sections Getting Started 10 lectures • 1hr 15min Introduction Preview 13:08 About Me 00:56 Download Course Materials 00:42 Enable the Developer Tab Preview 07:06 Excel File Types 04:00 Macro Security 08:43 The Macro Recorder 15:12 Record Macro to Change Worksheet Orientation 2 questions Absolute vs. Relative References I 08:12 Absolute vs. Relative References II 08:14 The Visual Basic Editor 09:01 VBA Basics 7 questions The Fundamentals of the Excel Object Model 7 lectures • 52min Object-Oriented Programming in Real Life Preview 11:29 Real Life Objects 3 questions Collection Objects in Real Life 05:50 Objects As Properties 09:08 The Excel Object Model 13:34 Access Object from Collection by Name 03:57 Default Properties 03:38 The Name Property on Workbook and Worksheet Objects 04:03 Object-Oriented Programming 6 questions The Visual Basic Editor 5 lectures • 50min Visual Basic Editor Options 13:39 Create and Delete a Procedure Preview 08:51 Procedures 5 questions The Immediate Window and Debug.Print Method 08:45 The MsgBox Method 13:34 Comments 05:18 Practice with Procedures 6 questions The Visual Basic Editor 11 questions Objects and Methods 6 lectures • 38min Methods without Arguments 03:28 Methods without Arguments 3 questions Methods with Arguments 08:30 Methods with Arguments 3 questions Methods with Multiple Arguments 06:42 The Object Browser 05:28 Ways to Invoke A Procedure 08:17 The TypeName Method 05:53 Objects and Methods 9 questions Variables and Data Types 13 lectures • 1hr 20min Syntax Tips 07:37 Variable Declarations and Assignments 10:01 Multiple Variable Declarations 04:14 The Option Explicit Setting 05:52 The Byte, Integer and Long Data Types 07:54 Numeric Data Types 3 questions Mathematical Operations 06:06 The Single and Double Data Types 05:59 The String Data Type 04:58 String and Double Data Types 5 questions The Boolean Data Type 04:24 The Date Data Type 06:22 The Variant Data Type 05:42 The Object Data Type 08:04 Default Values for Declared Variables 02:53 Variable Declarations 2 questions Procedures 7 lectures • 47min Variable Scope 09:30 Call A Procedure from Another one 03:54 Procedures with Arguments 07:15 Procedure Scope (Public vs. Private) 06:54 The Exit Sub Keywords 01:49 Constants 06:48 Predefined Constants Preview 11:00 Procedures 6 questions Object Deep Dive 14 lectures • 1hr 8min The Application Object 04:14 The Application.DisplayAlerts Property 06:26 The Workbooks.Count and Worksheets.Count Properties 02:07 The Workbooks.Open Method and Workbook.Path Property 06:59 The Workbooks.Close Method 01:47 The Workbooks.Add Method 05:56 The Workbook.SaveAs and Workbook.Save Methods 09:31 The Workbook.Activate Method 06:58 The Workbook.Close Method 04:13 The Application, Workbooks and Workbook Objects 6 questions The Worksheets.Add Method 05:27 Add a New Worksheet to End of Current List of Worksheets 1 question The Worksheet.Visible Property 05:11 The Worksheet.Copy Method 03:34 The Worksheet.Delete Method 02:24 The Worksheet.Move Method 02:58 Range References 15 lectures • 1hr 26min The Range.Select Method Preview 08:42 The Value vs. Text Properties 03:50 R1C1 Notation, Part I 09:53 R1C1 Notation, Part II 07:55 The Formula and FormulaR1C1 Properties 06:47 The Range.Offset Property 05:05 The Range.Resize Property 03:53 The Offset and Resize Properties 10 questions The Cells Property 04:43 The Range.CurrentRegion Property 05:00 The Range.End Property 08:24 The Range.Count and Range.CountLarge Properties 03:20 The Range.Row and Range.Column Properties 02:25 The Range.Rows and Range.Columns Properties 06:59 The Range.EntireRow and Range.EntireColumn Properties 02:54 Get Last Row of Data in Worksheet 06:23 Range Actions 14 lectures • 1hr 22min The Range.FillDown Method 05:01 The Range.Replace Method 04:42 The Range.TextToColumns Method 09:28 The Range.Worksheet Property 02:09 The Range.Sort Method 12:32 The Range.Font Property 09:07 The Range.Interior Property 06:41 The Range.ColumnWidth and Range.RowHeight Properties 06:27 The Range.AutoFit Method 02:58 The Range.Clear, Range.ClearContents and Range.ClearFormats Methods 04:02 The Range.Delete Method 05:53 The Range.Copy and Range.Cut Methods 04:00 The Paste and PasteSpecial Methods on the Worksheet Object 04:56 The Parent Property on All Objects 04:23 Conditionals 6 lectures • 46min Boolean Expressions 06:27 Boolean Expressions 9 questions The If Then Statement 04:05 The ElseIf and Else Statements 10:41 Select Case 10:41 The AND & OR Logical Operators 06:34 Logical Operators 14 questions The NOT Operator 07:27 8 more sections Instructor Boris Paskhaver Software Engineer | Consultant | Author 4.7 Instructor Rating 26,865 Reviews 303,386 Students 6 Courses Hi there, it's nice to meet you! I'm a New York City-based software engineer, author, and consultant who's been teaching on Udemy since 2016 . Like many of my peers, I did not follow a conventional approach to my current role as a web developer. After graduating from New York University in 2013 with a degree in Business Economics and Marketing, I worked as a business analyst, systems administrator, and data analyst for a variety of companies including a digital marketing agency, a financial services firm, and an international tech powerhouse. At one of those roles, I was fortunate enough to be challenged to build several projects with Python and JavaScript. There was no formal computer science education for me; I discovered coding entirely by accident. A small work interest quickly blossomed into a passionate weekend hobby. Eventually, I left my former role to complete App Academy, a rigorous full-stack web development bootcamp in NYC. The rest is history. I've always been fascinated by the intersection of technology and education, especially since I've struggled with many of the traditional resources people use to learn how to program. My goal as an instructor is to create comprehensive step-by-step courses that break down the complex details into small, digestible pieces. I like to build the kind of material that I myself would have loved to have when I was starting out . I'm passionate about teaching and would love to help you discover what code can do for you . See you in a course soon! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6780fcb56f4e4089',m:'212ab94c143cb026ba23a655a788a33ee6225cab-1627841048-1800-AfCHi8/BfmUZuDQxSrKsxTIYGrw802LvDBPT9YBC/pExOhKG2Ajz3ez565z7tMHHu/J9/KgncMplUuQH7gF4lsboCiqEsMzbhjlV7qKZXphq8JHMdwDSxJIL7acazBQQYhBNGkyJaxI9rHNn7cPqCTc=',s:[0xba2793dee7,0x2b7910be9f],}})();