Using macros and form controls -- Using the Visual Basic Editor -- Introducing Visual Basic for Applications -- Introducing the Excel object model -- Understanding arrays -- Controlling program flow -- Using Excel worksheet functions -- Debugging macros -- Working with workbooks and files -- Working with worksheets -- Defining ranges -- Working with lists -- Creating dialog boxes and customizing the ribbon -- Working with charts -- Working with pivottables -- Automating procedures with Excel events -- Building add-ins -- Understanding XML -- Appendix. VBA quick reference.
0
SUMMARY OR ABSTRACT
Text of Note
A great guide to Excel programming that is perfect for visual learners and takes you beyond Excel basics! This book is the perfect reference for Excel users who want to delve deeper into the application to create powerful and dynamic programs. From creating macros to customizing dialog boxes, this step-by-step guide helps you get more out of Excel than you knew was possible. Each step has callouts so you can see exactly where the action takes place and this Web site offers tons of usable code and sample macros that you can put to use instantly.
ACQUISITION INFORMATION NOTE
Source for Acquisition/Subscription Address
MIL
Stock Number
270825
OTHER EDITION IN ANOTHER MEDIUM
Title
Excel programming.
International Standard Book Number
9780470591598
PARALLEL TITLE PROPER
Parallel Title
Microsoft Excel programming
TITLE USED AS SUBJECT
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
TOPICAL NAME USED AS SUBJECT
Business-- Computer programs, Handbooks, manuals, etc.
Charts, diagrams, etc-- Computer programs, Handbooks, manuals, etc.
Electronic spreadsheets-- Computer programs, Handbooks, manuals, etc.