UEU-co logo

List of Figures

Previous Page

Next Page

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 Image from book 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.

Previous Page

Next Page

Leave a Reply

Time limit is exhausted. Please reload the CAPTCHA.


apply_now Pepperstone Group Limited