VBA manual（微软官方VBA手册）.pdf-资料库

mathexplorer-10384442-16359647239959680863.pdf-第1页.png

第1页 / 共94页

mathexplorer-10384442-16359647239959680863.pdf-第2页.png

第2页 / 共94页

mathexplorer-10384442-16359647239959680863.pdf-第3页.png

第3页 / 共94页

mathexplorer-10384442-16359647239959680863.pdf-第4页.png

第4页 / 共94页

mathexplorer-10384442-16359647239959680863.pdf-第5页.png

第5页 / 共94页

mathexplorer-10384442-16359647239959680863.pdf-第6页.png

第6页 / 共94页

mathexplorer-10384442-16359647239959680863.pdf-第7页.png

第7页 / 共94页

mathexplorer-10384442-16359647239959680863.pdf-第8页.png

第8页 / 共94页

MS Office 2010 MS Excel VBA Manual

Table of Contents INTRODUCTION ................................................................................................................... 1 VISUAL BASIC EDITOR .......................................................................................................... 2 VISUAL BASIC FOR APPLICATIONS (50 MINS) ................................................................. 2 THE PROJECT EXPLORER ........................................................................................... 4 THE PROPERTIES WINDOW ....................................................................................... 4 THE CODE WINDOW ................................................................................................ 4 OBJECT PROGRAMMING ....................................................................................................... 4 WHAT IS OBJECT PROGRAMMING? .............................................................................. 4 THE PROPERTIES WINDOW ....................................................................................... 4 MODIFYING PROPERTIES ........................................................................................... 5 USING THE CODE WINDOW ....................................................................................... 6 COLOURS IN THE CODE WINDOW ................................................................................ 7 USING METHODS .................................................................................................... 7 USING EVENTS ........................................................................................................ 8 OBJECT-ORIENTATED PROGRAMMING OVERVIEW ........................................................... 9 THE OBJECT BROWSER ........................................................................................... 11 UNIT SUMMARY .................................................................................................... 12 PROGRAMMING BASICS ...................................................................................................... 14 DATA 14 DATA TYPES ......................................................................................................... 14 VARIABLES ........................................................................................................... 15 IMPLICIT DECLARATION........................................................................................... 15 EXPLICIT DECLARATION ........................................................................................... 16 CONSTANTS.......................................................................................................... 16 EXPRESSIONS ........................................................................................................ 17 OPERATORS ......................................................................................................... 17 THE CELLS OBJECT ................................................................................................. 17 FUNCTIONS .......................................................................................................... 18 USER INTERACTION FUNCTIONS ................................................................................ 18 CONCATENATING TEXT............................................................................................ 19 OBJECT VARIABLES ................................................................................................ 20 -i -

SCOPE OF VARIABLES ............................................................................................. 21 DECLARATIONS SECTION ......................................................................................... 21 TYPES OF SCOPE .................................................................................................... 21 SCOPE OF PROCEDURES .......................................................................................... 22 PROCEDURE SCOPES ............................................................................................... 22 CALLING A SUB PROCEDURE ..................................................................................... 23 FUNCTION PROCEDURES ......................................................................................... 24 CALLING FUNCTION PROCEDURES.......................................................................................... 25 CALL A FUNCTION FROM CODE ................................................................................. 25 CALL A FUNCTION USING INSERT FUNCTION DIALOG BOX ................................................ 25 CONTROL STRUCTURES ....................................................................................................... 28 DECISION STRUCTURES ........................................................................................... 28 IF...THEN...ELSE CONSTRUCTION ............................................................................. 28 IF THEN STATEMENT ............................................................................................... 30 IF THEN ELSE STATEMENT ........................................................................................ 31 IF THEN ELSEIF ELSE STATEMENT ............................................................................... 31 SELECT CASE STATEMENT ........................................................................................ 32 LOOP STRUCTURES ................................................................................................ 33 THE FOR… NEXT LOOP ........................................................................................... 33 THE FOR EACH… NEXT LOOP ................................................................................... 35 DO…LOOP STATEMENTS......................................................................................... 36 DO WHILE LOOP ................................................................................................... 36 CUSTOM DIALOG BOXES ..................................................................................................... 38 USER FORMS ........................................................................................................ 38 DESIGNING THE USER FORM .................................................................................... 38 NAMING OBJECTS .................................................................................................. 38 USER FORM INTERFACE .......................................................................................... 39 ADDING A USER FORM ........................................................................................... 39 USING CONTROLS .................................................................................................. 40 ADDING USER FORMS ............................................................................................. 41 EVENTS 44 EVENT HANDLING CODE .......................................................................................... 45 DATA VALIDATION ................................................................................................. 47 FORM CHECK LIST ................................................................................................. 48

Excel VBA Intro "type section name here" DEBUGGING AND ERROR HANDLING ..................................................................................... 49 ERRORS 49 ERROR TYPES........................................................................................................ 49 ERROR TYPES........................................................................................................ 50 DEBUGGING ......................................................................................................... 51 DEBUGGING TOOLS ................................................................................................ 51 BREAK MODE AND BREAKPOINT ............................................................................... 51 SETTING A BREAKPOINT .......................................................................................... 52 WATCH EXPRESSIONS............................................................................................. 54 STEPPING THROUGH CODE....................................................................................... 55 USING THE STEP INTO ........................................................................................................ 56 DELETE WATCH EXPRESSIONS ................................................................................... 56 THE IMMEDIATE WINDOW ...................................................................................... 57 WORKING WITH THE INTERMEDIATE WINDOW ............................................................. 57 LOCALS WINDOW .................................................................................................. 59 ERROR-HANDLING ................................................................................................. 60 THE ON ERROR STATEMENT .................................................................................... 60 THE ON ERROR GOTO 0 .......................................................................................... 60 ON ERROR RESUME NEXT ....................................................................................... 60 ON ERROR GOTO :..................................................................................... 61 ENABLED AND ACTIVE ERROR HANDLERS ................................................................... 61 ERROR HANDLING BLOCKS AND ON ERROR GOTO ....................................................... 61 THE RESUME STATEMENT ....................................................................................... 62 ERROR HANDLING WITH MULTIPLE PROCEDURES ........................................................ 63 A NOTE OF CAUTION ............................................................................................. 64 THE EXCEL OBJECT MODEL ................................................................................................. 65 OBJECT REFERENCES: CELLS, SHEETS AND WORKBOOKS ................................................ 65 SQUARE BRACKETS ................................................................................................. 66 WITH…END WITH ................................................................................................ 66 APPENDIX A HOW TO SPEED UP CODE ................................................................................... 68 PREVENTING CALCULATION WHILE EXECUTING CODE: .................................................... 69 SPEEDING UP CODE IF YOU HAVE WORKSHEET OR WORKBOOK EVENTS. ........................... 69 INSERTING A RELATIVE FORMULA INTO A RANGE OF CELLS: ............................................. 69 APPENDIX B SAMPLE CODE ................................................................................................. 71 Page iii

COPY DATA TO ANOTHER WORK SHEET ..................................................................... 71 COPY DATA TO ANOTHER WORK BOOK ...................................................................... 74 FILTERING DATA.................................................................................................... 77 FILTER THE FIRST FIELD OF THE TABLE/LIST FOR THE INPUTBOX VALUE .............................. 77 ACTIVECELL VALUE AS CRITERIA ................................................................................ 78 FILTER THE FIRST FIELD OF THE TABLE/LIST FOR THE TEXT VALUE OF RANGE("D1") ............. 79 IN THE EXAMPLE I FILTER ON THE FIRST COLUMN FOR THE NETHERLANDS .......................... 82 MACRO TO CLEAR THE FILTER IN THE TABLE/LIST ......................................................... 83 PRINT ODD AND EVEN PAGES ................................................................................... 85 INSERT PAGE BREAKS EVERY ? ROWS ......................................................................... 86

Excel VBA Intro "type section name here" Page v

资料库

VBA manual（微软官方VBA手册）.pdf

相关推荐

开发技术

热门标签

最新资料