List of Tables

Chapter 3: Formula Tricks and Techniques

Table 3-1: COMPARING SIMPLE FORMULAS IN TWO NOTATIONS

Table 3-2: EXCEL ERROR VALUES

Table 3-3: COUNTING FORMULA EXAMPLES

Table 3-4: SUMMING FORMULA EXAMPLES

Table 3-5: INTERMEDIATE FORMULAS WRITTEN IN ROW 2 IN FIGURE 3-9

Chapter 4: Understanding Excel's Files

Table 4-1: EXCEL COMMAND LINE SWITCHES

Table 4-2: EXCEL FILE TYPES

Table 4-3: TEXT FILE TYPES

Table 4-4: DATABASE FILE TYPES

Table 4-5: OTHER FILE TYPES

Table 4-6: EXCEL CONFIGURATION INFORMATION IN THE REGISTRY

Chapter 5: What Is a Spreadsheet Application?

Table 5-1: CLASSIFICATION OF SPREADSHEET USERS BY EXPERIENCE AND INTEREST

Chapter 6: Essentials of Spreadsheet Application Development

Table 6-1: ACTIVEX CONTROLS VERSUS FORM CONTROLS

Chapter 7: Introducing Visual Basic for Applications

Table 7-1: PROPERTIES OF A COMMENT OBJECT

Table 7-2: METHODS OF A COMMENT OBJECT

Table 7-3: SOME USEFUL PROPERTIES OF THE APPLICATION OBJECT

Chapter 8: VBA Programming Fundamentals

Table 8-1: VBA BUILT-IN DATA TYPES

Table 8-2: VARIABLE SCOPE

Table 8-3: OPERATOR PRECEDENCE

Table 8-4: VBA LOGICAL OPERATORS

Chapter 10: Creating Function Procedures

Table 10-1: FUNCTION CATEGORIES

Chapter 11: VBA Programming Examples and Techniques

Table 11-1: SORTING TIMES (IN SECONDS) FOR FOUR SORT ALGORITHMS USING RANDOMLY FILLED ARRAYS

Chapter 12: Custom Dialog Box Alternatives

Table 12-1: CODES TO DETERMINE THE DATA TYPE RETURNED BY EXCEL'S INPUTBOX METHOD

Table 12-2: CONSTANTS USED FOR BUTTONS IN THE MSGBOX FUNCTION

Table 12-3: CONSTANTS USED FOR MSGBOX RETURN VALUE

Chapter 13: Introducing UserForms

Table 13-1: SPINBUTTON EVENTS

Chapter 15: Advanced UserForm Techniques

Table 15-1: COMPARING THE ENHANCED DATA FORM WITH THE EXCEL DATA FORM

Chapter 18: Working with Charts

Table 18-1: EVENTS RECOGNIZED BY THE CHART OBJECT

Chapter 19: Understanding Excel's Events

Table 19-1: WORKBOOK EVENTS

Table 19-2: WORKSHEET EVENTS

Table 19-3: EVENTS RECOGNIZED BY A CHART SHEET

Table 19-4: EVENTS RECOGNIZED BY THE APPLICATION OBJECT

Table 19-5: EVENTS RECOGNIZED BY A USERFORM

Table 19-6: KEY CODES FOR THE ONKEY EVENT

Chapter 26: Compatibility Issues

Table 26-1: EXCEL COUNTRY CODES

Table 26-2: PROPERTIES THAT HAVE LOCAL VERSIONS

Table 26-3: CONSTANTS FOR THE INTERNATIONAL PROPERTY

Chapter 27: Manipulating Files with VBA

Table 27-1: VBA FILE-RELATED COMMANDS

Table 27-2: FILE ATTRIBUTE CONSTANTS FOR THE DIR FUNCTION

Chapter 30: Working with Colors

Table 30-1: COLOR EXAMPLES

Table 30-2: THEME COLOR NAMES

Appendix A: Excel Resources Online

Table A-1: THE http://www.microsoft.com EXCEL-RELATED NEWSGROUPS

Appendix B: VBA Statements and Functions Reference

Table B-1: SUMMARY OF VBA STATEMENTS

Table B-1: SUMMARY OF VBA STATEMENTS

Table B-2: SUMMARY OF VBA FUNCTIONS

Table B-2: SUMMARY OF VBA FUNCTIONS

Table B-2: SUMMARY OF VBA FUNCTIONS