Book Image

Excel VBA Programming - The Complete Guide [Video]

By : Boris Paskhaver
4.5 (4)
Book Image

Excel VBA Programming - The Complete Guide [Video]

4.5 (4)
By: Boris Paskhaver

Overview of this book

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! All the code and supporting files for this course are available at - https://github.com/PacktPublishing/Excel-VBA-Programming---The-Complete-Guide
Table of Contents (17 chapters)
Chapter 1
Getting Started
Content Locked
Section 2
Enable the Developer Tab
The Developer Tab is a secret Tab on the Ribbon that includes several options for working with VBA. Users can access the Visual Basic Editor, enable the Macro Recorder, and display a list of public macros. In this lesson, we expose the Developer Tab and introduce some of its available commands.