A great way to learn to program with VBA is to work through a book. There are hundreds of these available now, at reasonable prices on Amazon. This is the method I used when I first learned to program in VBA and I highly recommend it. The following books are all good options.
Excel VBA Programming For Dummies
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition)
Excel VBA and Macros with MrExcel LiveLessons (Video Training)
The following websites are also great sources of information on macros:
Ozgrid - Excel and Macro guide/information
