Chapter 10. Use Dialog Box Controls on a Worksheet

Chapter at a Glance

image with no caption

In this chapter, you will learn to:

  • Add ActiveX controls to a worksheet.

  • Link the value of a control to a worksheet cell.

  • Link a list box to a worksheet range.

  • Create a list box with multiple columns.

  • Protect a worksheet that uses ActiveX controls.

Microsoft Office Excel 2007 is a great program. Many people purchase it to use at work. At least, people say they're going to use it at work. Of course, we all know the real reason most of us buy it is to calculate car payments. (The rest of us buy it to figure out mortgage payments.) It's after buying it that we discover that it's also good ...

Get Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.