Here is what we have to help:
1) Excel 2007 VBA CD:
http://www.mrexcel.com/sunshop/index.php?action=item&substart=0&id=133
This is a 3-day course that Dr. Gerry Verschuuren uses to teach people VBA. It is full-color, with about 1400 PowerPoint slides. Gerry adds "quiz" slides to make sure you are understanding the content as you go. It is designed to get you up to speed with VBA.
2) Holy Macro! It's 2,500 Excel VBA Examples CD:
http://www.mrexcel.com/sunshop/index.php?action=item&substart=0&id=1
This CD assumes you already know the basics of VBA. It provides searchable examples showing you how to do 2,500 tasks with Excel VBA. You will search for a topic, find the workbook, copy the code, paste into your project. This CD doesn't explain how things work, but assumes you can learn from example.
3) VBA & Macros for Microsoft Excel 2007 Book:
http://www.mrexcel.com/sunshop/index.php?action=item&substart=0&id=126
This is the book that Starl and I wrote to bring someone up to speed on Excel VBA. It assumes you know Excel really well and have maybe tried to record a macro. It talks about the problems with the macro recorder, how to record better macros, but then switches over to cover the syntax and operation of VBA.
4) Office VBA Macros You Can Use Today Book:
http://www.mrexcel.com/sunshop/index.php?action=item&substart=0&id=89
Once you've mastered Excel VBA, you might need to do something in Word, PowerPoint, Outlook or Access. This book is the rosetta stone, showing examples of common tasks in Word VBA, PowerPoint VBA, and so on.
Bill