On 11th October 2012, I delivered a webinar, Excel VBA 101. Aimed at VBA newbies, I provided an introduction to the world of VBA. The webinar lasted 1hr 10 minutes. Below is a 3 minute clip from the video in which I explain how to write code to display a dialog box to the user for data input.

If you missed the webinar then you’ll be glad to know that there’s a recording available – Over one hour of expert tuition on Excel VBA!

The recording can be obtained via The Excel Trainer.

In the webinar I covered the following topics:

  • What is VBA?
  • The Macro Recorder
  • The Developer Tab
  • A tour of the VBA Editor
  • Objects, Collections, Properties and Methods
  • Writing your First Sub Procedure
  • Manipulating Cell Content
  • Introduction to Variables
  • InputBox for User Input

I also demonstrated several examples of real-world VBA applications that I built myself including a certificate generator, an email generator, a training course feedback collection and analysis tool and a data entry form.