Chapter 23
(Almost) Ten Excel Resources
In This Chapter
Using the VBA Help system
Getting assistance from Microsoft
Finding help online
This book is only an introduction to Excel VBA programming. If you hunger for more information, feel free to feed on the list of additional resources I’ve compiled here. You can discover new techniques, communicate with other Excel users, download useful files, ask questions, and lots more.
The VBA Help System
I hope you’ve already discovered VBA’s Help system. I find this reference source particularly useful for identifying objects, properties, and methods. It’s readily available, it’s free, and (for the most part) it’s accurate. So use it.
If you use Excel 2013, be aware that VBA Help is entirely online. That means you must have an Internet connection to access the Help system.
Microsoft Product Support
Microsoft offers a wide variety of technical support options (some for free, others for a fee). To access Microsoft’s support services, go here:
And don’t forget about Microsoft’s Office site, which has lots of material related to Excel:
Another great resource is the Microsoft Developer Network site (MSDN). It has lots and lots of information aimed at the developer (yes, that is you!). Here is a link to the main site, where you can search for Excel-related information:
Internet Websites
Several websites contain Excel-related material. A good place to start your web surfing is my very own site, which is named The Spreadsheet Page. After you get there, you can check out my material and then visit my Resources section, which leads you to dozens of other Excel-related sites. The URL for my site is
Excel Blogs
You can find literally millions of blogs (short for weblogs) on the web. A blog is basically a frequently updated diary about a particular topic. Quite a few blogs are devoted exclusively to Excel. I maintain a list of Excel blogs at my site:
http://spreadsheetpage.com/index.php/excelfeeds
When I have a question about any topic (including Excel programming), my first line of attack is Google — currently the world’s most popular search site:
Enter a few key search terms (along with the word Excel or VBA) and see what Google finds. I get an answer about 90 percent of the time.
Bing
Bing is Microsoft’s answer to the Google search site. Some people prefer it over Google; others don’t. If you haven’t tried it, the URL is
Local User Groups
Many larger communities and universities have an Excel user group that meets periodically. If you can find a user group in your area, check it out. These groups are often an excellent source for contacts and sharing ideas.
My Other Books
Sorry, but I couldn’t resist the opportunity for a blatant plug. To take VBA programming to the next level, check out my Excel 2010 Power Programming with VBA or Excel 2013 Power Programming with VBA (both published by Wiley).