Excel(r) Programming 2nd Edition
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
Reihe
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Editions-Typ
Illustrationen
Maße
Höhe: 22.8 cm
Breite: 20.3 cm
Dicke: 22 mm
Gewicht
ISBN-13
978-0-7645-9781-7 (9780764597817)
Schweitzer Klassifikation
Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement includes programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Excel Programming: Your visual blueprint for creating interactive spreadsheets, and Windows CE 2 For Dummies.
HOW TO USE THIS BOOK.
GETTING STARED WITH EXCEL MACROS.
USING THE VISUAL BASIC EDITOR.
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.