Rather than distribute the actual presentation file from my Sunday PPTLive VBA Boot Camp session, I've posted all of the example code here.
I've also included lots of useful little code snippets, subroutines and functions that I won't have time to describe in our two-hour Boot Camp session, plus a setup guide.
Code examples
Code examples are formatted like this:
Sub WhereDoesTheCodeBeginAndEnd()
' Silly demo subroutine
' Code is formatted like this
Msgbox ("Yes. Exactly like this!")
' This helps you to know where the code begins and ends
' so you don't confuse it with the foolishness surrounding it
End Sub
Tips and tricks
Scattered throughout, you'll see hints and suggestions formatted like this:
These describe techniques that professional programmers use to make their code more readable, more maintainable and easier for others to work with.
We're not your mom, and your code will work even if you ignore these tips. But sooner or later, you'll be glad you paid attention, so ... PAY ATTENTION! Do what it says.