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
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.
MIL
270825
Excel programming.
9780470591598
Microsoft Excel programming
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Business-- Computer programs, Handbooks, manuals, etc.
Charts, diagrams, etc-- Computer programs, Handbooks, manuals, etc.
Electronic spreadsheets-- Computer programs, Handbooks, manuals, etc.