Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 120 key Excel programming techniques, including:
- Creating and launching keyboard shortcuts
- Setting macro security
- Assigning a digital signature
- Developing a function with VBA
- Displaying a built-in dialog box
- Converting a list into an array
- Using the msgbox function
- Processing a runtime error
- Saving a workbook in a specified format
- Finding the intersection of two ranges

- HOW TO USE THIS BOOK.
- VBA PROGRAMMING BASICS.
- WORKING WITH THE EXCEL OBJECT MODEL.
- USING VARIABLES AND ARRAYS.
- ADDING CONTROL STATEMENTS.
- USING BUILT-IN FUNCTIONS AND STATEMENTS.
- DEBUGGING MACROS.
- WORKING WITH OTHER WORKBOOKS AND FILES.
- WORKING WITH WORKSHEETS.
- DEFINING RANGES.
- WORKING WITH CELLS.
- CUSTOMIZING DIALOG BOXES, MENUS, AND TOOLBARS.
- WORKING WITH CHARTS.
- AUTOMATING PROCEDURES WITH EXCEL EVENTS.
APPENDIX A: VBA QUICK REFERENCE.
APPENDIX B: ABOUT THE CD-ROM.