xxxvi
Contents
Selecting a row or column .......................................................................................890
Moving a range........................................................................................................891
Looping through a range efficiently .........................................................................891
Prompting for a cell value........................................................................................893
Determining the type of selection ............................................................................893
Identifying a multiple selection ...............................................................................895
Counting selected cells ............................................................................................895
Working with Workbooks ................................................................................................896
Saving all workbooks ..............................................................................................896
Saving and closing all workbooks ............................................................................896
Working with Charts ........................................................................................................897
Modifying the chart type .........................................................................................898
Modifying chart properties ......................................................................................898
Applying chart formatting .......................................................................................899
VBA Speed Tips ................................................................................................................899
Turning off screen updating ....................................................................................899
Preventing alert messages ........................................................................................900
Simplifying object references ...................................................................................900
Declaring variable types ..........................................................................................901Chapter 45: Creating Custom Excel Add-Ins . . . . . . . . . . . . . . . . . . . . . . 903
What Is an Add-In? ...........................................................................................................903
Working with Add-Ins ......................................................................................................904
Why Create Add-Ins? ........................................................................................................906
Creating Add-Ins ..............................................................................................................907
An Add-In Example ..........................................................................................................908
Setting up the workbook .........................................................................................908
Procedures in Module1 ...........................................................................................909
About the UserForm................................................................................................909
Testing the workbook .............................................................................................910
Adding descriptive information ...............................................................................911
Protecting the project ..............................................................................................911
Creating the add-in .................................................................................................912
Creating the user interface for your add-in macro ..................................................912
Installing the add-in ................................................................................................913Part VII: Appendixes 915
Appendix A: Worksheet Function Reference . . . . . . . . . . . . . . . . . . . . . 917Appendix B: What’s on the CD-ROM . . . . . . . . . . . . . . . . . . . . . . . . . . . 933
System Requirements ........................................................................................................933
Using the CD ....................................................................................................................93302_474877-ftoc.indd xxxvi02_474877-ftoc.indd xxxvi 3/29/10 11:34 PM3/29/10 11:34 PM