Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Here are the chapters included in this course manual (we use exactly the same manuals for our classroom and online Visual Basic for Applications courses).
Click here to download a sample of the first two chapters of this Introducton to Excel VBA manual, or review how to license our courseware.
Section | Title |
---|---|
1.1 | The Visual Basic Editor |
1.2 | The VBE Screen |
1.3 | The Main VBE Windows |
1.4 | VBE Settings |
Section | Title |
---|---|
2.1 | Modules |
2.2 | Writing Procedures |
2.3 | Writing Neat Code |
2.4 | Writing Simple VBA Instructions |
2.5 | Tools to Help with Writing Code |
Section | Title |
---|---|
3.1 | Saving VBA Code |
3.2 | The Personal Macro Workbook |
3.3 | Opening Files Which Contain VBA Code |
3.4 | Trusted Documents |
Section | Title |
---|---|
4.1 | Running Code from Excel |
4.2 | Running Code from the VBE |
4.3 | When Things Go Wrong |
Section | Title |
---|---|
5.1 | Keyboard Shortcuts |
5.2 | Form Control Buttons |
5.3 | ActiveX Command Buttons |
5.4 | AutoShapes and Pictures |
5.5 | The Excel Ribbon |
Section | Title |
---|---|
6.1 | Referring to a Range Object |
6.2 | The Cells Property |
6.3 | Rows and Columns |
6.4 | Referring to the Active or Selected Cell |
6.5 | The Offset Property |
6.6 | The End Property |
6.7 | Referring to Regions of Cells |
6.8 | Referring to Special Cells |
6.9 | Referring to Used Cells |
Section | Title |
---|---|
7.1 | Excel Colours |
7.2 | Colour Numbers and Names |
Section | Title |
---|---|
8.1 | The MsgBox Function |
8.2 | Displaying Messages |
8.3 | Icons and Buttons |
Section | Title |
---|---|
9.1 | Asking Users for Input |
9.2 | Asking a Question with a Message Box |
9.3 | The VBA InputBox Function |
9.4 | The Excel-Specific InputBox Method |
Section | Title |
---|---|
10.1 | Data Types in VBA |
10.2 | Declaring and Using Variables |
10.3 | Declared vs. Non-Declared Variables |
10.4 | Variables and Data Types |
10.5 | Converting Variable Data Types |
10.6 | The Scope of Variables |
10.7 | Constants |
Section | Title |
---|---|
11.1 | Manipulating Data |
11.2 | Working with Numbers |
11.3 | Working with Dates |
11.4 | Working with Strings |
Section | Title |
---|---|
12.1 | The If Statement |
12.2 | Logical Tests and Operators |
12.3 | Combining Conditions |
12.4 | Comparing Strings |
12.5 | Conditional Functions |
12.6 | The Select Case Statement |
Section | Title |
---|---|
13.1 | The For Next Loop |
Section | Title |
---|---|
14.1 | The Do Loop |
14.2 | Do Until Loops |
14.3 | Do While Loops |
Section | Title |
---|---|
15.1 | Object Oriented Programming |
15.2 | Objects |
15.3 | Collections |
15.4 | Methods |
15.5 | Properties |
15.6 | Getting Help in VBA |
Section | Title |
---|---|
16.1 | Looping Through Collections |
16.2 | Looping Over Worksheets, Charts and Sheets |
16.3 | Looping Over the Workbooks Collection |
16.4 | Looping Over a Collection of Range Objects |
16.5 | Nesting For Each Loops |
Section | Title |
---|---|
17.1 | Modular Code |
17.2 | Breaking a Procedure into Parts |
17.3 | Procedures and Parameters |
17.4 | Writing Functions |
Section | Title |
---|---|
18.1 | Debugging Code |
18.2 | Running Code |
18.3 | Debugging Modular Code |
18.4 | Breakpoints |
18.5 | The Immediate Window |
18.6 | The Locals Window |
18.7 | The Watch Window |
18.8 | The Call Stack |
Section | Title |
---|---|
19.1 | Run-Time Errors in VBA |
19.2 | Error Handling in VBA |
19.3 | Using the On Error Statement |
19.4 | Creating a Custom Error Handler |
19.5 | Resuming After an Error |
19.6 | The Err Object |
Section | Title |
---|---|
20.1 | Event Handlers |
20.2 | Creating a Simple Event Handler |
20.3 | Workbook Events |
20.4 | Worksheet Events |
20.5 | ActiveX Controls |
Section | Title |
---|---|
21.1 | User Forms |
21.2 | Creating a User Form |
21.3 | Form Properties |
21.4 | Form Controls |
21.5 | Manipulating Controls |
21.6 | Laying Out Controls |
21.7 | Grouping Controls |
21.8 | Control Properties |
Section | Title |
---|---|
22.1 | Running a Form |
22.2 | Navigating a Form |
Section | Title |
---|---|
23.1 | Making Forms Work |
23.2 | Running User Forms |
23.3 | Adding Code to a Form |
23.4 | Referring to Forms and Controls |
23.5 | Form and Control Events |
23.6 | Validating User Inputs |
Section | Title |
---|---|
24.1 | Beyond the Basics |
24.2 | Frames |
24.3 | Combo Box and List Box Controls |
24.4 | Option Buttons |
24.5 | Check Boxes and Toggle Buttons |
24.6 | Spin Buttons and Scroll Bars |
24.7 | MultiPage Controls |
Section | Title |
---|---|
25.1 | Additional Form Controls |
25.2 | Examples of Extra Controls |
Section | Title |
---|---|
26.1 | Referencing Object Libraries |
26.2 | An Example for Word |
26.3 | An Example for PowerPoint |
26.4 | An Example for Outlook |
26.5 | Controlling Applications without References |
Section | Title |
---|---|
27.1 | Choosing an AI Tool |
27.2 | Getting Simple Code |
27.3 | Uploading Workbooks |
27.4 | A More Advanced Example |
27.5 | Optimising and Improving Code |
27.6 | Debugging |
27.7 | Global Changes and Reformatting |
Section | Title |
---|---|
28.1 | VBA Reference |
If you book a place on one of our courses you will automatically get access to the relevant courseware manual online, and also have the option to receive a paper copy of it.
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.