Table of Contents
1 Getting started 7
Introducing Excel VBA 8
Recording a macro 10
Viewing macro code 12
Testing a macro 14
Editing macro code 15
Referencing relatives 16
Saving macros 18
Trusting macros 20
Summary 22
2 Writing macros 23
Exploring the Editor 24
Creating a macro 26
Adding toolbar buttons 28
Adding Form Controls 30
Recognizing hierarchy 32
Identifying a range 34
Addressing cells 36
Summary 38
3 Storing values 39
Creating variables 40
Defining data types 42
Managing strings 44
Producing arrays 46
Describing dimensions 48
Representing objects 50
Declaring constants 52
Summary 54
4 Performing operations 55
Doing arithmetic 56
Making comparisons 58
Assessing logic 60
Joining strings 62
Understanding precedence 64
Summary 66
5 Making statements 67
Choosing a branch 68
Branching alternatives 70
Selecting branches 72
Performing loops 74
Looping while true 76
Breaking from loops 78
Iterating for each 80
Including with 82
Summary 84
6 Executing procedures 85
Calling subroutines 86
Modifying scope 88
Passing arguments 90
Adding modules 92
Fixing values 94
Debugging code 96
Handling errors 98
Summary 100
7 Employing functions 101
Defining a function 102
Calling a function 104
Scoping a function 106
Passing array arguments 108
Stating options 110
Returning errors 112
Debugging functions 114
Describing functions 116
Summary 118
8 Recognizing events 119
Creating event-handlers 120
Opening workbook events 122
Changing workbook events 124
Closing workbook events 126
Spotting worksheet changes 128
Catching worksheet clicks 130
Listening for keystrokes 132
Observing the time 134
Summary 136
9 Opening dialogs 137
Acquiring input 138
Showing messages 140
Importing files 142
Saving files 144
Producing data forms 146
Executing Ribbon commands 148
Summary 150
10 Providing UserForm dialogs 151
Inserting a UserForm 152
Adding controls 154
Comparing control types 156
Adjusting properties 158
Naming controls 160
Displaying forms 162
Handling form events 164
Managing lists 166
Summary 168
11 Developing apps 169
Ignoring modes 170
Indicating progress 172
Controlling MultiPages 174
Tabbing data pages 176
Showing chart info 178
Creating Add-ins 180
Installing Add-ins 182
Adding Ribbon buttons 184
Summary 186
Index 187