Visual Basic for Applications (VBA) Resources

Christopher Rath

2011-01-18

I have had cause to write some MS Access, Excel, PowerPoint, and Word VBA code over the years, and these pages are an attempt to capture and share the functions and techniques I have created and utilise on my PC:

• MS Access Tips
• MS Excel Tips
• MS PowerPoint Tips
• MS Word Tips

Other Resources

In my search for VBA code to use in my own projects, I have found the following websites to be very helpful:

• Chip Pearson's website — an excellent resource; very helpful; lots of useful Excel VBA code snippets.
• the O'Reilly "Word Hacks" book.
• Build an Excel Add-In — a good starter page for beginning Excel VBA programmers.
• John Walkenbach's Excel developer tips — another bunch of great Excel programming tips.
• ExcelExperts.com