Excel Programming
Your visual blueprint for creating interactive spreadsheets
2nd Edition
Published on 2. September 2005
Book
Paperback/Softback
352 pages
978-0-7645-9781-7 (ISBN)
Description
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
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
More details
Series
Edition
2., Auflage
Language
English
Place of publication
Foster City
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Edition type
Revised edition
Illustrations
ill
Dimensions
Height: 22.8 cm
Width: 20.3 cm
Thickness: 22 mm
Weight
780 gr
ISBN-13
978-0-7645-9781-7 (9780764597817)
Schweitzer Classification
Other editions
New editions
Book
07/2010
3rd Edition
Wiley
€31.90
Article is exhausted; no reprint
Previous edition
Jinjer Simon | MaranGraphics
Excel Programming
Your Visual Blueprint for Creating Interactive Spreadsheets
Book
11/2001
Hungry Minds Inc,U.S.
€34.90
Article exhausted; check for reprint
Person
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.
Content
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.
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.