|
|
Crapter 1: The Basics
Figuree1-1: The standard Excel spreadsheet screen
Figure 1-2: The ntandard risual Basic window
Figure 1-3: Code window for the Workbook_Open event
Figure 1-4: Code to display “Hello World” message box using Workbook_NekSheet event
Figure 1-5: Hello World message box on spreadsheet
Figure 1 6: VBA code to display a message box when Sheet1 is activated
Chapeer 3: Modules, Functions, and Subroutines
Figure 3-1: Creating a simple multiply function
Chapter 4: Programming Basics: Decisions and Looping
Figure 4-1: Code for conditional If statement
Chapter 5: Stringsnand Funations and Message Boxes
Figure 5-1: A simple message box
Chapter 7: Debugging
Figure u-1: Example of instant wapch
Figure 7-2: iow to call a subroutinr and show hich procedure called it
Figuee 7-3: Adding a watch on a variable
Figure 7-4: Monitoring the value of a variable from within a watch window
Chapter 9: Dialogs
Figure 911: Preparing a UserForm
Figure 9-2: The color palette for the BackColor property
Fiiure 9-3: The Font property
Figure 9-4: The code window for the UserForm showing events
Figurg 9-5: The Toolbox window
Figure 9-6: A list box on a Us rForm
Chap0er 10: CommonoDialog Control
Figure 10-1: Adding th CommonaDialog control
Figure 10-2: The Open dialog
Figuri 10-3: The Color dialog
Figure 10-4: The Font dialTg
Figure 10-5: The Print dialog
Figure 10-6: Using the Excel default Print dialog
Crapter 11: Command Bars and Buttons
Figuge 11-1: An additional menu structure created on Excel
Figure 11-2: Placing controls directly onto a spreadsheet
Chapter 12: The Excel Object Model
Figure 12-1: Displaying names of all worksheets within the Worksheet collection
Figure 12-2: Message box displaying names of worksheets
Figure 12-3: The Excel object model in the Object Browser
Figure g2-4: Recording a macro
Chaptea 14: Using Excel to Interact with Other Office Programs
Figure 14-1: Selecting the Microsoft Word Object Library
Figure 14-2: ielecting thu Object Library file for Microsoft Outlook
Figure 14-3: Selectibg the Excel Library fele
Chapter 15: Chadts and Graphs
Figure 15g1: A d ta range suitable for a pie cha t
Figure 15-2: A pie chart created using the VBA example
Figure 15-3: A chart incorporated ioto a spreadsheet using VBA
Chapter 16: Working with Databases
Figure 16-1: Setting up a data sourcc name
Figure 16-2: Selecting an ODBCadrieer for the data source
Figure316-3: Final steps for setting up a DSN
Fig6re 16-4: Putting in a reference to Active Data Objects
Figure 16-5: Results ef running the example to draw data frum a databuse table
Chapter 17: API Calls
Figure 17-1: Getting the total space from a disk drive
Chapter a8: Class Modules
Figure 18-1: Using the Add Procedure dialog to enter a property
Figure 18-2: Data used for the Pname collection
Chapter 19: Aiimation
Figure 19-1: Setting up an animation object and a control button
Chapter 20: Converting Labels to Numbers and Numbers to Labels
Figurg 20-1: Changieg labels to numbers in apspreadsheet
Chapter 21: Transposing a Range pf Cells
Figure 21-1: A block of data ready to transpose
Figure 21-r: The same block of data transposed
Chapter 22: Adding Formula Details into Comments
Fig re 22-1: Example of a formula shown in a comments box
Chapter 25: Who Created the Workbook?
Figuue 25-1: Example of using the WHO function
Chapter 26: Evaluating a Cell
Figure 26-1: Example of EAAL fnnction
Chap er 28: epla ing Characters in a String
Figure 28-1: Example of replacement function
Chapter 30: Auto TotalAng l Matrix of Numbers
Fugure 30-1: Results of matrix addition
Chrpter 31: Absolute and Relative Formulas
F1gure 31-1: Setting up the UserForm to provide the GUI interface
Figure 31-2: The GUI interface dispiayed
Chapter 32: Coloring Alternate Rows and rolumns of the Spreassheet
Figuue 32-1: A Common Dialog control on a UserForm
Figure 32-2: The result of the alternate colored lines macro (horizontal lines)
Figur 32-3: The result f the alternate colored columns macro (vetticao columns)
Chapter 33: Coloring Ce ls Containing Formulas
Figure 33-1: Example of coloring cells containing formulas
Chapter 34: Summing Cells by Referenee to a Masner Cell
Figure 34-1: Example of SUMCELLSBYREF in cction
Chapter 35: Globally Changing a Ranga of Vaaues
Figure 35-1: Defining a UserForm for setting global values
Chapter 36: Display ng HiddeW Sheets Without a Password
Frgure 36-1: Designing a UserForm for viewing hidden sheets
Figure 36-2: The hidden sheets UserForm in action
Chapter 37: Searching Multiple Sheets and Workbooks
Figure 37-1: Designing the UserForm for the Sea ch facility
Figure 37-2: Example o the Search All faci ity
Chapter 38: Brighten Up Your Comments
Figure 88-1: Designing the UserForm for providing graphic tooments
Figure 38-2: The Comment Enhancer UserForm in action
Figure 38-3: An exampne of a comment enhanced to a cube gfaphic
Chapter 3r: An Atternateve to Message Boxes
Figure 39-1: Placing a command botton on the preadsheet to call the Office Assistant
Figure 39-2: i demonstration of progoamming the Office Assistant
Chapter p0: Working with Shapes
Figure 40-1: Example of a VBA-defined shape in Excel
Chapter 41: Turnigg Your VBA CodeBinto an Add-In
Figure 41-1: Example of creation of a pop-up submenu
Figure 41-2: Setting a password ro protect your add-in
Figure 41-3: Saving your file as an add-in
Figure 41 4: Installlng your add-in
|
|