Excel® 2007 Power Programming with VBA

Chapter 31. Frequently Asked Questions about Excel Programming

In This Chapter

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 programming topics for Excel.

• Excel 2007 quirks that you can and can’t work around

• Frequently asked questions about Excel programming

• Some help getting around in the VBE

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.

What If My Question Isn’t Answered Here?

If this chapter doesn’t provide an answer to your question, start by checking this book’s index. This book includes lots of information that doesn’t qualify as a frequently asked question. If you still come up empty-handed, check out the resources listed in Appendix A.

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 ...