VBA Programming in Excel

In This Chapter

^ Working with Excel-related objects ^ Accessing and using Excel objects ^ Changing the contents of individual cells ^ Creating your own functions to use in Excel ^ Adding pizzazz to your Excel worksheet ^ Defining your own special-purpose worksheets icrosoft Excel provides a wealth of opportunities for custom VBA programs. You can do everything from creating special equations to designing eye-grabbing presentations. With some effort, you can create detailed graphs and charts on the fly. It's also possible to design self-checking worksheets, where a press of a button verifies the data you entered.

Of all the Office products, the third-party add-in product market for Excel is the largest and includes a vast array of product types, including add-ins that you can use with your VBA programs. Although you probably wouldn't want to write War and Peace with Excel, products are available that you can use to turn it into a simple word processor. Many products provide advanced math modeling and other calculation tasks. You'll also find an assortment of graphics products designed to make charting easier.

You should always check for an existing solution before you write a program that you have to debug and maintain. However, you still need to write programs for Excel because the potential of this program is far from exhausted. This chapter provides the tools that you need in order to write exceptional Excel programs so that you can complete your work quickly and easily. The content focuses on the worksheet instead of on charts because you'll likely spend more time in that area.

0 0

Post a comment