title: Excel VBA: A Beginners' Guide
author: Rajan E
description: Rajan has been working in Corporate firm and has rich knowledge in scripting and automation tools like VBA, selenium and AutoIT. He has keen interest in developing and programming areas. He loves to automate task which is repetitive and time consuming. His hobbies are blogging, writing and reading books. He is having much interest to learn programming languages and develop useful things out of it. He always love to share known information and knowledge with others.
zlib_text: 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Excel VBA:
  
  
  The Ultimate Intermediate's Guide to Learn VBA Programming Step by Step.
  
  
  David A. Williams
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  Table Of Contents
  
  
  
  
  
  [Introduction](text00003.html#a4JA)
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 1.
  
  
  ​
  
  
  VBA Integrated development environment
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 2.
  
  
  ​
  
  
  Control Program Flow and Making Decisions in Visual Basic for Application
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 3.
  
  
  ​
  
  
  How to Avoid Common Mistakes in Excel VBA
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 4.
  
  
  ​
  
  
  Interacting with the user
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 5.
  
  
  ​
  
  
  The “Speed Search Control Panel And Timing Comparison” Application
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 6.
  
  
  ​
  
  
  Performing Statistical Analysis Using Formulas
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 7.
  
  
  ​
  
  
  Scenario Building with One-way Data Table
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 8.
  
  
  ​
  
  
  An Event Macro
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 9.
  
  
  ​
  
  
  The Macro Recorder
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 10
  
  
  .
  
  
  
  
  
  The Excel Object Model
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chapter 11
  
  
  .
  
  
  
  
  
  Derived Data Types in VBA
  
  
  
  
  
  
  
  
  
  
  
  [
  
  
  Chap