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

Size2.46 MB
File typepdf
Downloads1037
Created2019-04-30
Cover of Excel VBA tutorial for professionals
Preview PDF

Download

  • Excel Basics: Microsoft Office 2013

    This course is intended to beginning computer users. You are only expected to know how to use the mouse and keyboard, open a program, and turn the computer on and off. You should also be familiar with the Microsoft Windows operating system....

  • PowerPoint Presentation

    This PDF tutorial introduces you to the basic features of PowerPoint which are particularly valuable in the teaching and learning environment....

  • Microsoft Excel 2016 Academic Course

    ...

  • Evaluating Information Retrieval and Access Tasks

    Download free course Evaluating Information Retrieval and Access Tasks, pdf file on 225 pages by Tetsuya Sakai, Douglas W. Oard, Noriko Kando....

  • Excel 2016 Shortcuts

    With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners....

  • Microsoft PowerPoint 2013 step by step

    This courses is designated to beginning-level and intermediate-level computer users. It teach you some skills that can be used to make a beutiful presentation....

  • Excel 2016 Math with Dates and Times

    With this tutorial, you will learn a lot of shortcuts and custom formatting options about Dates and Times in Excel 2016. Training documents courses on 17 pages for beginners....

  • Basic Formulas in Excel

    Download basic formulas in Excel tutorial, free training document in PDF under 6 pages by Lauren Wicks....

  • Commonly Used Excel Functions

    Here are some basic formulas that are easy to do and that can give some life to an Excel sheet!, download free PDF training document under 17 pages....

  • 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 ....