O'Reilly logo

Excel® 2010 Power Programming with VBA by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 31: Frequently Asked Questions about Excel Programming

IN THIS CHAPTER

Understanding Excel quirks

Exploring FAQs about Excel programming

Getting VBE help

Getting the Scoop on FAQs

If you like to cruise the Internet, you're undoubtedly familiar with FAQs — lists of frequently asked questions (and their answers) about a particular topic. FAQs are prevalent in the discussion groups and are posted in an attempt to reduce the number of messages that ask the same questions over and over again. They rarely serve their intended purpose, however, because the same questions keep appearing despite the FAQs.

I've found that people tend to ask the same questions about Excel programming, so I put together a list of FAQs that cover the following programming topics for Excel:

Excel quirks that you can and can't work around

Frequently asked questions about Excel programming

Some help getting around in the Visual Basic Editor

Although this FAQ list certainly won't answer all your questions, it covers many common questions and might set you straight about a thing or two.

I organized this list of questions by assigning each question to one of these categories:

General Excel questions

The Visual Basic Editor (VBE)

Sub procedures

Function procedures

Objects, properties, methods, and events

UserForms

Add-ins

Excel user interface modification

In some cases, my classifications are rather arbitrary; a question could justifiably be assigned to other categories. Moreover, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required