Learn from the Wise Owl VBA guru!

Trying to learn to write VBA macros in Excel?  Our Andrew Gould has packed most of what he knows about VBA into a single, must-have book:

VBA Excel book

Over 340 pages of VBA goodness!

Read on to discover why this is the best book you can buy if you're teaching yourself to program in VBA in Excel (you'll also find out how to purchase it).

If you don't care about the details and you just want to purchase a copy you can do so here!

About the author

Andrew is uniquely well-placed to write this book.  Not only does he have an encyclopaedic knowledge of VBA (memorably, he rewrote the Flappy Bird app entirely in VBA - check out Flappy Owl), but he's also not bad at passing this knowledge on, in the form of classroom training, videos and blogs:

Medium Notes
Classroom Andrew has run 176 classroom courses on VBA in the last 10 years, training 705 people in total.
Videos Author of nearly 100 separate videos on VBA, all viewable through this site.
Blogs Co-author (with me, as it happens) of an entire VBA tutorial (also viewable on this site).

Any computer book requires two ingredients, rarely found in the same person:

Computer book recipe

Wise Owl are uniquely well-placed to offer this book on learning VBA in Excel (and who knows, there may even be others in the future).

About the book

Here's the front cover of our Introduction to Excel VBA book:

Introduction to Excel VBA

Here are the contents:

Chapter Title Pages
1 The Visual Basic Editor 6
2 Writing Simple VBA Code 14
3 Saving and Opening Files 6
4 Running VBA Code 8
5 Basic User Interfaces 8
6 Workbooks and Worksheets 10
7 Working With Ranges 14
8 Colours in VBA 2
9 Displaying Messages 6
10 User Inputs 10
11 Variables and Data Types 12
12 Constants and Enumerations 4
13 Working with Data 10
14 Testing Conditions 10
15 For Next Loops 4
16 Conditional Loops 4
17 How VBA Works 12
18 For Each Loops 6
19 Modular Code, Parameters and Functions 10
20 Recursive Programming 4
21 Debugging 10
22 Handling Errors 12
23 Arrays 8
24 Events 14
25 Creating User Forms 14
26 Running User Forms 4
27 Adding Code to Forms 12
28 Advanced Form Controls 16
29 Controlling Other Applications 16
30 Shapes 18
31 Connecting to Databases 14
32 Files and Folders 8
33 File Dialog Boxes 6
34 Class Modules 12
35 Collections and Dictionaries 12
36 VBA Quick Reference 6

The book comes with a full table of contents at the beginning and index at the end, and is printed on A4 paper, double-sided.

How to buy the book

If you like what you've read so far, you can purchase Introduction to Excel VBA here.

Lulu is a website which prints books on demand, and ships them anywhere in the world.  If you're based in the UK and ordering more than 10 copies, you can also contact us directly about purchasing the book.

One final thing ...

To get the table above, I needed to go through all of the Word chapters stored on the Wise Owl network, getting the page number and chapter title for each.  I could have done this manually, but it would have taken ages and I'd have made lots of errors.  So instead I wrote a VBA program - and here it is:

Sub ListContents()

'to do with files and folders

Dim fso As New FileSystemObject

Dim fol As Folder

Dim ChapterFile As File

Dim doc As Document

'chapter and page numbering

Dim ChapterNumber As Integer

Dim PageCount As Integer

Dim PageNumber As Integer

'other variables used

Dim TableText As String

Dim ChapterName As String

'initially we have no chapters and no pages

TableText = ""

PageCount = 0

ChapterNumber = 0

'get location of files on Wise Owl drive (part omitted)

Set fol = fso.GetFolder("Q:\...")

'for each file

For Each ChapterFile In fol.Files

'check if it is a Word document

If Right(LCase(ChapterFile.Name), 5) = ".docx" Then

'get the chapter name

ChapterName = Left(ChapterName, InStr(1, ChapterName, ".") - 1)

'open the document and get page number at end

Set doc = Documents.Open(ChapterFile.Path)

Selection.EndKey Unit:=wdStory

PageNumber = Selection.Information(wdActiveEndPageNumber)

'close it back down again

doc.Close savechanges:=False

'add on this chapter number (some HTML omitted from string)

TableText = TableText & _

" HTML here " & ChapterNumber & " HTML here " & _

ChapterName & " HTML here " & PageNumber & _

" HTML here " & vbCrLf

'increase page count

PageCount = PageCount + PageNumber

End If

Next ChapterFile

'finished - show result in immediate window

Debug.Print TableText

End Sub

I've only included this to show what's possible.  The code above won't run on its own, and is not meant in any way to be part of a tutorial, but it does show one reason why VBA is useful to learn!

This page has 1 thread Add post
27 Sep 17 at 01:12

My Introduction to Excel VBA has Arrived:

Andrew Gould: This one is for you!

Andrew, I know you have heard this before. However, it is worth repeating. You are the best. Everything I have learned about Excel VBA, I have learned from your videos. I watched your videos on Youtube for the past six months, and I have learned so much about Excel VBA is that time. About a week and a half ago I was trying to figure out how to get your courseware from all the way in Maryland, USA. Then I saw the Introduction to Excel VBA, and I had to have it.

Andrew, thank you again for all you do. Please let me know when the Advanced VBA book is ready for purchase. I can't wait.

Kind Regards

Logan A.



27 Sep 17 at 07:46

Hi Logan, many thanks for purchasing the book! I hope that you're enjoying it and finding it useful.

At the moment I'm not sure whether there will be an Advanced VBA book - this Introduction to Excel VBA book includes chapters on every topic that we cover on both our Introduction and Advanced VBA training courses. There are certainly more advanced things we could write about VBA but I think we'll wait to see how well this one sells first!

Thanks again and happy reading!