10 Places to Turn for Excel Macro Help - dummies

10 Places to Turn for Excel Macro Help

By Michael Alexander

No one can become an Excel macro expert in one day. VBA is a journey of time and practice. The good news is that there are plenty of resources out there that can help you on your path. Here are ten of the most useful places to turn to when you need an extra push in the right direction.

Letting Excel write the macro for you

One of the best places to get macro help is Macro Recorder in Excel. When you record a macro with Macro Recorder, Excel writes the underlying VBA for you. After recording, you can review the code; see what the recorder is doing, and then try to turn the code it creates into something more suited to your needs.

Using the VBA Help files

If you learn how to use the Excel Help system effectively, it will often be the fastest and easiest way to get help on a topic. You need to remember two basic tenants of the Excel Help system:

  • Location matters when asking for help. Excel has two Help systems. One provides help with Excel features and the other provides help with VBA programming topics. Instead of doing a global search with your criteria, Excel throws your search criteria only against the Help system relevant to your current location.

  • Online help is better than offline help. When you search for help on a topic, Excel checks to see whether you’re connected to the Internet. Online help is generally better than offline help because the content you find with online help is often more detailed and includes updated information, as well as links to other resources not available offline.

Pilfering code from the Internet

The dirty secret about programming in the Internet age is that there is no longer any original code. All the macro syntax that anyone will ever need has been documented somewhere on the Internet.

If you’re stuck trying to create a macro for a particular task, fire up your favorite online search engine and describe the task you’re trying to accomplish. For the best results, enter Excel VBA before your description.

For example, if you’re trying to write a macro that deletes all blank rows in a worksheet, search for Excel VBA delete blank rows in a worksheet.

Leveraging user forums

If you find yourself in a bind, you can post your question in a forum and get customized guidance. User forums are online communities that revolve around a particular topic. In these forums, you can post a question and experts will offer advice.

Many forums are dedicated to all things Excel. To find an Excel forum, enter the words Excel forum in your favorite online search engine.

Here are a few tips for getting the most out of user forums:

  • Read and follow the forum rules before you get started.

  • Use a concise and accurate subject title for your question.

  • Keep the scope of your question narrow.

  • Be patient. Give the community some time to answer your question.

  • Check back often. After posting your question, you may receive requests for more details about your scenario.

  • Thank the expert who answered your question. Take a moment to post a thank-you to the expert who helped you out.

Visiting expert blogs

Several dedicated Excel gurus share their knowledge through blogs. These blogs are often treasure troves of tips and tricks, offering nuggets that can help build your skills. Best of all, they’re free!

Here is a list of a few of the best Excel blogs on the Internet today:

  • ExcelGuru: Ken Puls is a Microsoft Excel MVP who shares knowledge on his blog. In addition to his blog, Ken offers several learning resources for advancing your knowledge in Excel.

  • Chandoo.org: Purna “Chandoo” Duggirala is a Microsoft Excel MVP out of India who burst on the scene in 2007. His innovative blog offers many free templates and article that are aimed at “making you awesome in Excel.”

  • Contextures: Debra Dalgleish is a Microsoft Excel MVP and the owner of a popular Excel site. With an alphabetized list of over 350 Excel topics, the site is sure to provide you with something of interest.

  • DailyDose: Dick Kusleika is the owner of the longest-running Excel blog. He is the king of Excel VBA blogging, with over ten years’ worth of articles and examples.

  • MrExcel: Bill Jelen is a larger-than-life ambassador of Excel. This long-time Excel MVP offers over a thousand free videos and a huge library of training resources on his site.

Mining YouTube for video training

Some people learn better if they watch a task being done. If you find that you absorb video training better than online articles, consider mining YouTube. You might be surprised at how many free high-quality video tutorials you can find, run by amazing folks who have a passion for sharing knowledge.

Search YouTube for the words Excel VBA.

Attending live and online training classes

Live and online training events are an awesome way to absorb Excel knowledge from a diverse group of people. Not only is the instructor feeding you techniques, but the lively discussions during the class can provide a wealth of ideas and new tips. If you thrive in the energy of live training events, consider searching for Excel classes.

Here are a few site that provide excellent instructor-led Excel courses:

Learning from Microsoft Office Dev Center

The Microsoft Office Dev Center site is dedicated to helping new developers get a quick start in programming Office products. Go to the Excel portion of this site.

Although the site can be a bit difficult to navigate, it’s worth a visit to see all the free resources, including sample code, tools, and step-by-step instructions.

Dissecting other Excel files in your organization

Like finding gold in your backyard, the existing files in your organization are often a treasure trove for learning. Open Excel files that contain macros, and see how others in your organization use them. Try to go through the macros line-by-line and see if you can spot new techniques.

You could find a few new tricks you never thought of. You may even stumble upon entire chunks of useful code you can copy and implement in your own workbooks.

Asking your local Excel genius

Do you have an Excel genius in your company, department, organization, or community? Make friends with that person today. You’ll have your own personal Excel forum.

Most Excel experts love sharing their knowledge. So don’t be afraid to approach your local Excel guru to ask questions or seek out advice on how to tackle certain macro problems.