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.