Excel VBA tutorial for professionals

Download free VBA tutorial course in PDF, training file in 31 chapters and 128 pages. Free unaffiliated ebook created from Stack OverFlow contributor.

Table of contents

  • About
  • Getting started with Excel VBA
  • Opening the Visual Basic Editor (VBE)
  • Declaring Variables
  • Adding a new Object Library Reference
  • Hello World
  • Getting Started with the Excel Object Model
  • Arrays
  • Dynamic Arrays (Array Resizing and Dynamic Handling)
  • Populating arrays (adding values)
  • Jagged Arrays (Arrays of Arrays)
  • Check if Array is Initialized (If it contains elements or not)
  • Dynamic Arrays [Array Declaration, Resizing]
  • Conditional statements
  • The If statement
  • Ranges and Cells
  • Ways to refer to a single cell
  • Creating a Range
  • O?set Property
  • Saving a reference to a cell in a variable
  • How to Transpose Ranges (Horizontal to Vertical & vice versa)
  • Named Ranges
  • De?ne A Named Range
  • Using Named Ranges in VBA
  • Manage Named Range(s) using Name Manager
  • Named Range Arrays
  • Merged Cells / Ranges
  • Think twice before using Merged Cells/Ranges
  • Locating duplicate values in a range
  • Find duplicates in a range
  • User De?ned Functions (UDFs)
  • Allow full column references without penalty
  • Count Unique values in Range
  • UDF - Hello World
  • Conditional formatting using VBA
  • FormatConditionsAdd
  • Remove conditional format
  • FormatConditionsAddUniqueValues
  • FormatConditionsAddTop10
  • FormatConditionsAddAboveAverage
  • FormatConditionsAddIconSetCondition
  • Workbooks
  • When To Use ActiveWorkbook and ThisWorkbook
  • Changing The Default Number of Worksheets In A New Workbook
  • Application Workbooks
  • Opening A (New) Workbook, Even If It's Already Open
  • Arrays
  • Ranges and Cells
  • Merged Cells / Ranges
  • User Defined Functions (UDFs)
  • Workbooks
  • Loop through all Sheets in Active Workbook
  • Methods for Finding the Last Used Row or Column in a Worksheet
  • File System Object
  • Binding
  • Application object
  • CustomDocumentProperties in practice
  • How to record a Macro
  • Excel-VBA Optimization
  • Debugging and Troubleshooting
  • Excel VBA Tips and Tricks

It is a free VBA ebook created for beginners. The content is extracted from Stack Overflow pltaform, which is written by many VBA developers and contributors.

The content is released under Creative Commons BY-SA

Size : 2.46 MB
File type : pdf
Downloads: 943
Created: 2019-04-30

Others VBA Tutorials

VBA API Tutorial

VBA Tutorials for professionals

Introduction to Excel VBA Macro programming

VBA Excel 2010, 2013 and 2016 Tutorial in PDF

Introduction to VBA in Excel - PDF Tutorial

Others related eBooks about Excel VBA tutorial for professionals

Advanced Microsoft Excel 2013

Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for beginners....

Microsoft Excel Tips & Tricks

These are some of my favorite tips and power features that’ll get you well on your way to ‘Excel Guru Status’ giving you not only the recognition you deserve, but also making your work more enjoyable....

Essential PowerShell

This book written to provide clear and concise explanation of topics for programmers both starting to learn the PowerShell programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....

Office 365

Written for the IT professional and business owner, this book provides the business and te..., download free Office tutorial in PDF (680 pages) created by Don Crawford ....

Quick guide to Microsoft Excel 2016

Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf....

Quick guide to Word 2010

A course to learn how to use the Word 2010 version, PDF training course to download for free, Microsoft Office Word 2010, training support in 4 pages...

Microsoft Excel 2013 for beginner

Download free Microsoft Office Excel 2013 Tutorial course material, tutorial training, PDF file on 25 pages....

The Beginner’s Guide to Microsoft Excel

This is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...

Microsoft Word 2016 free tutorial

Download free Microsoft Word 2016 course material and training (PDF file 214 pages)...

Office 365: Migrating and Managing Your Business in the Cloud

Written for the IT professional and business owner, this book provides the business and technical insight necessary to migrate your business to the cloud using Microsoft Office 365. This is a practical look at cloud migration and the use of different technologies to support that migration. Numerous ...