List of Figures

Chapter 1: Excel 2007-Where It Came From

Figure 1-1: VisiCalc, running in a DOS window on a PC running Windows XP.

Figure 1-2: The original Excel 2.1 for Windows. This product has come a long way.

Figure 1-3: Excel 3 was a vast improvement over the original release.

Figure 1-4: Excel 4 was another significant step forward, although still far from Excel 5.

Figure 1-5: Excel 2007 uses a new Ribbon user interface.

Chapter 2: Excel in a Nutshell

Figure 2-1: A pie chart on a chart sheet.

Figure 2-2: The Home tab of the Ribbon.

Figure 2-3: The Home tab when Excel's window is narrower.

Figure 2-4: The Home tab when Excel's window is very narrow.

Figure 2-5: When you select an object, contextual tabs contain tools for working with that object.

Figure 2-6: The Paste command is a split button control.

Figure 2-7: This small dialog launcher icon displays a dialog box that has additional options.

Figure 2-8: Add new icons to your QAT by using the Customization section of the Excel Options dialog box.

Figure 2-9: Pressing Alt displays the keytips.

Figure 2-10: Right-clicking some objects displays a mini-toolbar.

Figure 2-11: Tabbed dialog boxes make many options accessible without overwhelming the user.

Figure 2-12: This Smart Tag appears when you paste a copied range.

Figure 2-13: Locating clip art is one of several uses for the task pane.

Figure 2-14: Excel can monitor your formulas for possible errors.

Figure 2-15: The Insert Function dialog box is the best way to insert a function into a formula.

Figure 2-16: Excel's numeric formatting options are very flexible.

Figure 2-17: The data bars option is one of the new conditional formatting features in Excel 2007.

Figure 2-18: The Protect Sheet dialog box.

Figure 2-19: The Protect Workbook dialog box.

Figure 2-20: Use the Encrypt Document dialog box to save a workbook with a password.

Figure 2-21: Protecting a VBA project with the Project Properties dialog box.

Figure 2-22: Excel 2007 charts have improved in the looks department.

Figure 2-23: A SmartArt diagram.

Figure 2-24: Excel's new table feature makes it easy to sort and filter rows.

Figure 2-25: Create a Web Query to import data into a worksheet.

Figure 2-26: Excel's pivot table feature has many applications.

Figure 2-27: Excel's Help window.

Chapter 3: Formula Tricks and Techniques

Figure 3-1: An example of using nonrelative references in a formula.

Figure 3-2: Excel makes it easy to create names that use descriptive text in your worksheet.

Figure 3-3: The Name Manager displays the scope for each defined name .

Figure 3-4: Excel lets you name constants that don't appear in worksheet cells .

Figure 3-5: You can name a formula that doesn't appear in any worksheet cell .

Figure 3-6: Cell B1 contains an array formula that returns the total number of characters contained in range A1:A5. Notice the brackets in the formula bar.

Figure 3-7: A single multicell array formula is all it takes to make a calendar for any month in any year.

Figure 3-8: This simple worksheet demonstrates some useful formulas for counting and summing.

Figure 3-9: The Extended Date Functions add-in lets you work with pre-1900 dates.

Figure 3-10: Removing the middle names and initials requires six intermediate formulas.

Chapter 4: Understanding Excel's Files

Figure 4-1: Starting Excel from the Windows Run dialog box.

Figure 4-2: Customizing a shortcut to launch Excel.

Figure 4-3: Templates that you can use for invoices.

Figure 4-4: A simple workbook.

Figure 4-5: The directory structure of the workbook file.

Figure 4-6: Viewing an XML file in a Web browser.

Figure 4-7: Excel can often repair a damaged workbook file.

Figure 4-8: Viewing a QAT data file in Excel.

Figure 4-9: The Registry Editor lets you browse and make changes to the Registry.

Figure 4-10: Setting a value for a Registry setting.

Chapter 6: Essentials of Spreadsheet Application Development

Figure 6-1: An example of a customized shortcut menu.

Figure 6-2: A dialog box created with Excel's UserForm feature.

Figure 6-3: You can add dialog box controls to worksheets and link them to cells.

Figure 6-4: Worksheet controls.

Figure 6-5: Using the Protect Sheet dialog box to specify what users can and cannot do.

Figure 6-6: An example of custom help file for an Excel add-in.

Chapter 7: Introducing Visual Basic for Applications

Figure 7-1: By default, the Developer tab is not displayed.

Figure 7-2: The Visual Basic Editor window.

Figure 7-3: A Project Explorer window with three projects listed.

Figure 7-4: Your first VBA procedure.

Figure 7-5: The result of running the procedure in Figure 7-4.

Figure 7-6: The Editor tab of the Options dialog box.

Figure 7-7: An example of Auto List Members .

Figure 7-8: An example of Auto Quick Info offering help about the Cells property.

Figure 7-9: The Editor Format tab of the Options dialog box.

Figure 7-10: The General tab of the Options dialog box.

Figure 7-11: The Docking tab of the Options dialog box.

Figure 7-12: A convenient window arrangement for watching the macro recorder do its thing.

Figure 7-13: The main help screen for the Comment object.

Figure 7-14: The Object Browser is a great reference source.

Chapter 8: VBA Programming Fundamentals

Figure 8-1: VBA's way of telling you that your procedure contains an undeclared variable.

Figure 8-2: VBA displays a list of constants that can be assigned to a property.

Figure 8-3: Displaying a list of VBA functions in the VBE.

Chapter 9: Working with VBA Sub Procedures

Figure 9-1: The Macro dialog box.

Figure 9-2: The Macro Options dialog box lets you assign a Ctrl key shortcut and an optional description to a procedure.

Figure 9-3: The References dialog box lets you establish a reference to another workbook.

Figure 9-4: Assigning a macro to a button.

Figure 9-5: Executing a procedure by entering its name in the Immediate window.

Figure 9-6: VBA error messages aren't always user friendly.

Figure 9-7: You can create a message box to display the error code and description.

Figure 9-8: The SpecialCells method generates this error if no cells are found.

Figure 9-9: Use the VBE Immediate window to test a statement.

Figure 9-10: An empty procedure in a module located in the Personal Macro Workbook.

Figure 9-11: This message box tells the user that the sheets cannot be sorted.

Figure 9-12: This message box appears before the sheets are sorted.

Chapter 10: Creating Function Procedures

Figure 10-1: Using a custom function in a worksheet formula.

Figure 10-2: Using a custom function in a VBA procedure.

Figure 10-3: Calling a Function procedure from the Immediate Window.

Figure 10-4: Using a function to display the result of a calculation.

Figure 10-5: Different ways of passing an array or a single value to a worksheet.

Figure 10-6: Comparing SUM with MySum.

Figure 10-7: Use the Immediate window to display results while a function is running.

Figure 10-8: Inserting a custom function into a formula.

Figure 10-9: Provide a function description in the Macro Options dialog box.

Chapter 11: VBA Programming Examples and Techniques

Figure 11-1: The number of rows in the data range changes every week.

Figure 11-2: This workbook uses a custom shortcut menu to demonstrate how to select variably sized ranges by using VBA.

Figure 11-3: The InputBox function gets a value from the user to be inserted into a cell.

Figure 11-4: Validate a user's entry with the VBA InputBox function.

Figure 11-5: A macro for inserting data into the next empty row in a worksheet.

Figure 11-6: Use an input box to pause a macro.

Figure 11-7: A VBA procedure analyzes the currently selected range.

Figure 11-8: Using the intersection of the used range and the selected ranged results in fewer cells to process.

Figure 11-9: The goal is to duplicate rows based on the value in column B.

Figure 11-10: New rows were added, according to the value in column B.

Figure 11-11: Using Excel's InputBox method to prompt for a cell location.

Figure 11-12: All rows and columns are hidden, except for a range (G8:K17).

Figure 11-13: Using VBA to count the number of printed pages in a workbook.

Figure 11-14: A message box displaying the date and time.

Figure 11-15: Listing font names in the actual fonts.

Figure 11-16: Comparing the time required to perform sorts of various array sizes.

Figure 11-17: The RangeRandomize function returns the contents of a range, in random order.

Figure 11-18: Determining the path and name of the application associated with a particular file.

Figure 11-19: Using Windows API functions to get disk drive information.

Figure 11-20: Getting information about the active printer by using a Windows API call.

Figure 11-21: Using a Windows API call to determine the video display mode.

Chapter 12: Custom Dialog Box Alternatives

Figure 12-1: VBA's InputBox function at work.

Figure 12-2: Using VBA's InputBox function with a long prompt.

Figure 12-3: Using the InputBox method to specify a range.

Figure 12-4: Excel's InputBox method performs validation automatically.

Figure 12-5: The buttons argument of the MsgBox function determines which buttons appear.

Figure 12-6: Splitting a message into multiple lines.

Figure 12-7: This message box displays text with tabs and line breaks.

Figure 12-8: The GetOpenFilename method displays a dialog box used to specify a file.

Figure 12-9: Use an API function to display this dialog box.

Figure 12-10: Using the FileDialog object to select a directory.

Figure 12-11: This dialog box was displayed with a VBA statement.

Figure 12-12: Using the ExecuteMso method to display a dialog box.

Figure 12-13: Some users prefer to use Excel's built-in data form for data-entry tasks .

Chapter 13: Introducing UserForms

Figure 13-1: The Properties window for an empty UserForm.

Figure 13-2: Use the Toolbox to add controls to a UserForm.

Figure 13-3: This UserForm has one of each of the 15 controls.

Figure 13-4: Use the Format Align command to change the alignment of controls.

Figure 13-5: Six controls, aligned and evenly spaced .

Figure 13-6: Selecting a control (CheckBox3) from the drop-down list at the top of the Properties window.

Figure 13-7: The Help system provides information about each property for every control.

Figure 13-8: Use the Tab Order dialog box to specify the tab order of the controls.

Figure 13-9: This dialog box asks the user to enter a name and a sex.

Figure 13-10: The CommandButton1_Click procedure is executed when the button on the worksheet is clicked.

Figure 13-11: The CommandButton's Click event procedure displays the UserForm.

Figure 13-12: The event list for a CheckBox control.

Figure 13-13: This SpinButton is paired with a TextBox.

Figure 13-14: The Toolbox, with a new page of controls.

Figure 13-15: The Additional Controls dialog box lets you add other ActiveX controls.

Chapter 14: UserForm Examples

Figure 14-1: This dialog box uses CommandButtons as a menu.

Figure 14-2: This dialog box uses a ListBox as a menu.

Figure 14-3: The RefEdit control shown here allows the user to select a range.

Figure 14-4: This splash screen is displayed briefly when the workbook is opened.

Figure 14-5: A sample dialog box in its standard mode.

Figure 14-6: The same dialog box enlarged to show some options.

Figure 14-7: Here, ScrollBar controls allow zooming and scrolling of the worksheet.

Figure 14-8: Setting the RowSource property at design time.

Figure 14-9: A Collection object is used to fill a ListBox with the unique items from column B.

Figure 14-10: This message box displays a list of items selected in a ListBox.

Figure 14-11: The contents of this ListBox depend on the OptionButton selected.

Figure 14-12: Building a list from another list.

Figure 14-13: The buttons allow the user to move items up or down in the ListBox.

Figure 14-14: This ListBox displays a three-column list with column headers.

Figure 14-15: A two-column ListBox filled with data stored in an array.

Figure 14-16: This ListBox makes it easy to select rows in a worksheet.

Figure 14-17: This dialog box lets the user activate a sheet.

Figure 14-18: MultiPage groups your controls on pages, making them accessible from a tab.

Figure 14-19: The Date and Time Picker Control in a UserForm.

Figure 14-20: Inserting a date using the Date and Time Picker Control.

Figure 14-21: Generating a random number.

Figure 14-22: A random number has been chosen .

Chapter 15: Advanced UserForm Techniques

Figure 15-1: This modeless dialog box remains visible while the user continues working.

Figure 15-2: This modeless UserForm displays various information about the active cell.

Figure 15-3: A UserForm displays the progress of a macro.

Figure 15-4: This UserForm will serve as a progress indicator.

Figure 15-5: The user specifies the number of rows and columns for the random numbers .

Figure 15-6: Page2 of the MultiPage control will display the progress indicator.

Figure 15-7: The progress indicator will be hidden by reducing the height of the UserForm.

Figure 15-8: The progress indicator in action.

Figure 15-9: This four-step wizard uses a MultiPage control.

Figure 15-10: Clicking the Cancel button displays a confirmation message box.

Figure 15-11: The result of the MsgBox emulation function.

Figure 15-12: The UserForm for the MyMsgBox function.

Figure 15-13: The three Image controls can be dragged and rearranged by using the mouse.

Figure 15-14: This UserForm lacks a title bar.

Figure 15-15: Another UserForm without a title bar.

Figure 15-16: A UserForm set up to function as a toolbar.

Figure 15-17: The UserForm that simulates a toolbar.

Figure 15-18: This is a resizable UserForm.

Figure 15-19: The UserForm after being increased in size .

Figure 15-20: VBA code converts Label control movements into new Width and Height properties for the UserForm.

Figure 15-21: Many CommandButtons with a single event-handler procedure.

Figure 15-22: The ButtonGroup_Click procedure describes the button that was clicked.

Figure 15-23: This dialog box lets the user select a color by specifying the red, green, and blue components .

Figure 15-24: The user's ScrollBar values are stored in the Windows Registry and retrieved the next time the GetAColor function is used.

Figure 15-25: With a bit of trickery , a UserForm can display "live" charts.

Figure 15-26: Excel's Data Form.

Figure 15-27: My Enhanced Data Form.

Figure 15-28: A sliding tile puzzle in a UserForm.

Chapter 16: Developing Excel Utilities with VBA

Figure 16-1: Use the Text Tools utility to change the case of selected text.

Figure 16-2: The UserForm for the Text Tools utility.

Figure 16-3: The UserForm layout changes for each operation.

Figure 16-4: This message is displayed if no workbook is active or if the active sheet is not a worksheet.

Figure 16-5: Use the Windows Registry Editor program to view the settings stored in the Registry.

Figure 16-6: The Text Tools utility includes a single level of undo.

Figure 16-7: A help screen for the Text Tools utility.

Figure 16-8: The Ribbon contains a new group in the Home tab.

Figure 16-9: The files in text tools.xlam.

Figure 16-10: An easier way to modify the Ribbon.

Chapter 17: Working with Pivot Tables

Figure 17-1: This simple table is a good candidate for a pivot table.

Figure 17-2: A pivot table created from the data in Figure 17-1.

Figure 17-3: The data in this workbook will be summarized in a pivot table.

Figure 17-4: A pivot table created from the budget data.

Figure 17-5: The Pivot Table Field List.

Figure 17-6: Creating a series of pivot tables will summarize this survey data.

Figure 17-7: Six of the 28 pivot tables created by a VBA procedure.

Figure 17-8: The summary table on the left will be converted to the table on the right.

Figure 17-9: This dialog box asks the user for the ranges.

Chapter 18: Working with Charts

Figure 18-1: The macro recorder was turned on while this chart was created and customized.

Figure 18-2: A few lines of VBA code created this chart.

Figure 18-3: Attempting to delete one or more chart sheets results in this message.

Figure 18-4: These charts use different formatting.

Figure 18-5: A simple macro applied consistent formatting to the four charts.

Figure 18-6: A chart, before and after being formatted.

Figure 18-7: Applying a shadow to a chart.

Figure 18-8: This chart has a bevel effect.

Figure 18-9: This chart always displays the data from the row of the active cell.

Figure 18-10: This workbook demonstrates how to expand and contract the chart series by using VBA macros.

Figure 18-11: An XY chart with no data labels.

Figure 18-12: This XY chart has data labels, thanks to a VBA procedure.

Figure 18-13: The chart in this UserForm is created on the fly from the data in the active row.

Figure 18-14: Selecting an event in the code module for a Chart object.

Figure 18-15: Activating the chart causes Chart_Activate to display this message.

Figure 18-16: This chart serves as a clickable image map.

Figure 18-17: Using CheckBox controls to specify which data series to display.

Figure 18-18: A confusing line chart is less confusing when some of the data columns are hidden.

Figure 18-19: This chart uses data from arrays (not stored in a worksheet).

Figure 18-20: After converting a chart to a picture, you can manipulate it by using a variety of commands.

Figure 18-21: A text box displays information about the data point under the mouse pointer.

Figure 18-22: Range B7:C9 contains data point information that's displayed in the text box on the chart.

Figure 18-23: A simple VBA procedure will turn this graph into an interesting animation.

Figure 18-24: The values in column F determine which data to display in the chart.

Figure 18-25: The chart displays a subset of the data, determined by the values of two named cells.

Figure 18-26: This workbook generates hypocycloid curves.

Figure 18-27: This clock is fully functional and is actually an XY chart in disguise.

Figure 18-28: Displaying a digital clock in a worksheet is much easier but not as much fun to create.

Figure 18-29: This application uses a variety of techniques to plot monthly climate data for two selected U.S. cities.

Figure 18-30: Use the Data Validation drop-down list to select a city.

Figure 18-31: The chart uses the data retrieved by formulas in A23:M24.

Chapter 19: Understanding Excel's Events

Figure 19-1: The components for each VBA project are listed in the Project window.

Figure 19-2: The best way to create an event procedure is to let the VBE do it for you.

Figure 19-3: This message box was triggered by a SheetActivate event.

Figure 19-4: You can cancel the print operation by changing the Cancel argument.

Figure 19-5: When this message appears, Workbook_BeforeClose has already done its thing.

Figure 19-6: This message box describes the problem when the user makes an invalid entry.

Figure 19-7: The Worksheet_Change procedure ensures that data validation does not get deleted.

Figure 19-8: Moving the cell cursor causes the active cell's row and column to be shaded.

Figure 19-9: This workbook uses a class module to monitor all Application-level events.

Figure 19-10: This message box was programmed to display at a particular time of day.

Figure 19-11: Pressing Shift+F10 displays this message.

Chapter 20: Interacting with Other Applications

Figure 20-1: Running the Windows Calculator program from Excel.

Figure 20-2: Use VBA to display a Control Panel dialog box.

Figure 20-3: The workbook that displays this dialog box demonstrates how to run system dialog boxes from Excel.

Figure 20-4: Adding a reference to an object library file.

Figure 20-5: Use the Object Browser to learn about the objects in a referenced library.

Figure 20-6: Word automatically generates three memos based on this Excel data.

Figure 20-7: An Excel procedure created this Word document.

Figure 20-8: A VBA procedure in Word uses this worksheet.

Figure 20-9: The Word VBA procedure uses Excel to create this document.

Figure 20-10: This information is used in the Outlook e-mail messages.

Figure 20-11: An Outlook e-mail message created by Excel.

Figure 20-12: Using Excel to send e-mail via Outlook normally causes a warning message from Outlook.

Figure 20-13: This information is used in the Outlook Express e-mail messages.

Figure 20-14: This Outlook Express message uses data stored in a worksheet.

Figure 20-15: This data was retrieved from an Access database.

Chapter 21: Creating and Using Add-Ins

Figure 21-1: Excel warns you if an add-in uses a non-standard file extension.

Figure 21-2: The Add-Ins dialog box.

Figure 21-3: Use the Document Properties panel to enter descriptive information about your add-in.

Figure 21-4: The Add-Ins dialog box with the new add-in selected.

Figure 21-5: Making an add-in not an add-in.

Figure 21-6: One very direct way to remove a member of the AddIns collection.

Figure 21-7: A table that lists all members of the AddIns collection.

Figure 21-8: When attempting to open the add-in incorrectly, the user sees this message.

Chapter 22: Working with the Ribbon

Figure 22-1: The Home tab of the Ribbon, with varying widths of the Excel window.

Figure 22-2: Using the Customize tab of the Excel Options dialog box to determine the name of a control.

Figure 22-3: A workbook that displays information about each Ribbon control.

Figure 22-4: An Excel workbook, displayed as a ZIP file.

Figure 22-5: RibbonX code created a new group with two buttons.

Figure 22-6: The Office 2007 Custom UI Editor.

Figure 22-7: This check box control is always in synch with the page break display of the active sheet.

Figure 22-8: A new Ribbon tab with four groups of controls.

Figure 22-9: A Ribbon group with four controls.

Figure 22-10: Three controls in a custom Ribbon group.

Figure 22-11: This group contains built-in controls.

Figure 22-12: This Ribbon group contains two galleries.

Figure 22-13: A gallery that displays month names, plus a button.

Figure 22-14: A gallery of photos.

Figure 22-15: The dynamicMenu control lets you create a menu that varies depending on the context.

Figure 22-16: An old-style toolbar, located in the Custom Toolbars group of the Add-Ins tab.

Chapter 23: Working with Shortcut Menus

Figure 23-1: A simple macro generates a list of all shortcut menus.

Figure 23-2: Displaying the Caption property for controls.

Figure 23-3: Listing the items in all shortcut menus.

Figure 23-4: The Cell shortcut menu with a custom menu item.

Figure 23-5: This shortcut menu has a submenu with three submenu items.

Figure 23-6: A new shortcut menu appears only when the user right-clicks a cell in the shaded area of the worksheet.

Chapter 24: Providing Help for Your Applications

Figure 24-1: Using cell comments to display help.

Figure 24-2: Using a shape object with text to display help for the user.

Figure 24-3: Putting user help in a separate worksheet is an easy way to go.

Figure 24-4: Clicking one of the arrows on the SpinButton changes the text displayed in the Labels.

Figure 24-5: Inserting a Label control inside a Frame control adds scrolling to the Label.

Figure 24-6: Using a drop-down list control to select a help topic.

Figure 24-7: Displaying help in a Web browser.

Figure 24-8: Displaying an MHTML file in a Web browser.

Figure 24-9: An example of HTML Help.

Figure 24-10: Using the HTML Help Workshop to create a help file.

Figure 24-11: Specify a context ID for a custom function in the Member Options dialog box.

Chapter 25: Developing User-Oriented Applications

Figure 25-1: This amortization schedule shows details for a 30-year mortgage.

Figure 25-2: Step 1 of the Loan Amortization Wizard.

Figure 25-3: Step 2 of the Loan Amortization Wizard.

Figure 25-4: Step 3 of the Loan Amortization Wizard.

Figure 25-5: Step 4 of the Loan Amortization Wizard.

Figure 25-6: Step 5 of the Loan Amortization Wizard.

Figure 25-7: A new group on the Insert tab contains one control.

Figure 25-8: This form is displayed when the Loan Amortization Wizard is opened.

Figure 25-9: User help is presented in a UserForm that copies text stored in a worksheet.

Figure 25-10: If an invalid entry is made, the focus is set back to the control that contains the error.

Figure 25-11: The Windows Registry stores the default values for the wizard.

Chapter 26: Compatibility Issues

Figure 26-1: The Compatibility Checker.

Figure 26-2: The Wizard Demo in English, Spanish, and German.

Chapter 27: Manipulating Files with VBA

Figure 27-1: Output from the ListFiles procedure.

Figure 27-2: Creating a reference to the Windows Script Host Object Model.

Figure 27-3: Output from the ShowDriveInfo procedure.

Figure 27-4: A table of information about the files in a directory.

Figure 27-5: This text file was generated by VBA.

Figure 27-6: A worksheet range, ready to be converted to HTML.

Figure 27-7: The worksheet data after being converted to HTML.

Figure 27-8: The data in this range will be converted to XML.

Figure 27-9: The worksheet data after being converted to XML.

Figure 27-10: When opening an XML file, Excel offers three options.

Figure 27-11: This dialog box lets the user select the files to be zipped .

Figure 27-12: The user is informed when the ZIP file is complete.

Figure 27-13: This Explorer window shows the ZIP file contents.

Chapter 28: Manipulating Visual Basic Components

Figure 28-1: Adding a reference to the Microsoft Visual Basic for Applications Extensibility Library.

Figure 28-2: This message box displays information about the references for a project.

Figure 28-3: The result of executing the ShowComponents procedure.

Figure 28-4: The message box lists all procedures in the active workbook.

Figure 28-5: This message box informs the user that a module will be replaced .

Figure 28-6: This sheet, the CommandButton, and its event handler were added by using VBA.

Figure 28-7: VBA generated this event handler procedure.

Figure 28-8: A VBA procedure added the CommandButtons on this UserForm.

Figure 28-9: This UserForm and its underlying code were generated on the fly.

Figure 28-10: The GetOption function generated this UserForm.

Figure 28-11: The UserForm adjusts its height and width to accommodate the number of options and the length of the text.

Chapter 29: Understanding Class Modules

Figure 29-1: An empty class module named NumLockClass.

Figure 29-2: The Auto List Members feature displays the available properties and methods .

Chapter 30: Working with Colors

Figure 30-1: Choosing a color using the HSL color system.

Figure 30-2: The DECIMAL2RGB function converts a decimal color value to its red, green, and blue components.

Figure 30-3: This workbook demonstrates how red, green, and blue colors combine.

Figure 30-4: A color-selection control.

Figure 30-5: This workbook demonstrates how the TintAndShade property affects a color.

Figure 30-6: A VBA macro generated these theme colors.

Figure 30-7: A Shape object on a worksheet.

Figure 30-8: Typing a statement with the assistance of the Auto List Members feature.

Figure 30-9: A Shape object with a two-color gradient fill.

Figure 30-10: This Shape uses a diamond-pattern fill.

Figure 30-11: A Shape that uses a picture.

Figure 30-12: A shape with a texture fill and a few other accoutrements.

Figure 30-13: A Shape object that contains text.

Figure 30-14: A simple column chart.