UEU-co logo

List of Tables


Previous Page

Next Page

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

Previous Page

Next Page
Tags:  

Leave a Reply


Time limit is exhausted. Please reload the CAPTCHA.

Categories

apply_now Pepperstone Group Limited