Book description
All the methods and tools you need to successfully program with Excel.
John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, “Mr. Spreadsheet” shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)
Features invaluable advice from “Mr. Spreadsheet” himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications
Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won't find anywhere else
Includes a CD with templates and worksheets from the book
This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Table of contents
- Cover
- Table of Contents
- Title Page
- Introduction
-
Part I: Some Essential Background
- Chapter 1: Excel 2010: Where It Came From
-
Chapter 2: Excel in a Nutshell
- Thinking in Terms of Objects
- Workbooks
- Excel's User Interface
- Customizing the Display
- Data Entry
- Formulas, Functions, and Names
- Selecting Objects
- Formatting
- Protection Options
- Charts
- Shapes and SmartArt
- Database Access
- Internet Features
- Analysis Tools
- Add-Ins
- Macros and Programming
- File Format
- Excel's Help System
- Chapter 3: Formula Tricks and Techniques
- Chapter 4: Understanding Excel Files
- Part II: Excel Application Development
-
Part III: Understanding Visual Basic for Applications
-
Chapter 7: Introducing Visual Basic for Applications
- Getting Some BASIC Background
- Delving in to VBA
- Covering the Basics of VBA
- Introducing the Visual Basic Editor
- Working with the Project Explorer
- Working with Code Windows
- Customizing the VBE Environment
- The Macro Recorder
- About Objects and Collections
- Properties and Methods
- The Comment Object: A Case Study
- Some Useful Application Properties
- Working with Range Objects
- Things to Know about Objects
- Chapter 8: VBA Programming Fundamentals
- Chapter 9: Working with VBA Sub Procedures
-
Chapter 10: Creating Function Procedures
- Sub Procedures versus Function Procedures
- Why Create Custom Functions?
- An Introductory Function Example
- Function Procedures
- Function Arguments
- Function Examples
- Emulating Excel's SUM function
- Extended Date Functions
- Debugging Functions
- Dealing with the Insert Function Dialog Box
- Using Add-ins to Store Custom Functions
- Using the Windows API
- Chapter 11: VBA Programming Examples and Techniques
-
Chapter 7: Introducing Visual Basic for Applications
-
Part IV: Working with UserForms
- Chapter 12: Custom Dialog Box Alternatives
-
Chapter 13: Introducing UserForms
- How Excel Handles Custom Dialog Boxes
- Inserting a New UserForm
- Adding Controls to a UserForm
- Toolbox Controls
- Adjusting UserForm Controls
- Adjusting a Control's Properties
- Displaying a UserForm
- Closing a UserForm
- Creating a UserForm: An Example
- Understanding UserForm Events
- Referencing UserForm Controls
- Customizing the Toolbox
- Creating UserForm Templates
- A UserForm Checklist
- Chapter 14: UserForm Examples
-
Chapter 15: Advanced UserForm Techniques
- A Modeless Dialog Box
- Displaying a Progress Indicator
- Creating Wizards
- Emulating the MsgBox Function
- A UserForm with Movable Controls
- A UserForm with No Title Bar
- Simulating a Toolbar with a UserForm
- A Resizable UserForm
- Handling Multiple UserForm Controls with One Event Handler
- Selecting a Color in a UserForm
- Displaying a Chart in a UserForm
- Making a UserForm Semitransparent
- An Enhanced Data Form
- A Puzzle on a UserForm
- Video Poker on a UserForm
-
Part V: Advanced Programming Techniques
- Chapter 16: Developing Excel Utilities with VBA
- Chapter 17: Working with Pivot Tables
-
Chapter 18: Working with Charts
- Getting the Inside Scoop on Charts
- Creating an Embedded Chart
- Creating a Chart on a Chart Sheet
- Using VBA to Activate a Chart
- Moving a Chart
- Using VBA to Deactivate a Chart
- Determining Whether a Chart Is Activated
- Deleting from the ChartObjects or Charts Collection
- Looping through All Charts
- Sizing and Aligning ChartObjects
- Exporting a Chart
- Changing the Data Used in a Chart
- Using VBA to Display Arbitrary Data Labels on a Chart
- Displaying a Chart in a UserForm
- Understanding Chart Events
- Discovering VBA Charting Tricks
- Animating Charts
- Creating an Interactive Chart without VBA
- Working with Sparkline Charts
- Chapter 19: Understanding Excel's Events
- Chapter 20: Interacting with Other Applications
- Chapter 21: Creating and Using Add-Ins
- Part VI: Developing Applications
- Part VII: Other Topics
- Part VIII: Appendixes
Product information
- Title: Excel® 2010 Power Programming with VBA
- Author(s):
- Release date: April 2010
- Publisher(s): Wiley
- ISBN: 9780470475355
You might also like
book
VBA and Macros: Microsoft® Excel® 2010
AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: …
book
VB & VBA in a Nutshell: The Language
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts …
book
Microsoft® Access® 2010 VBA Programming Inside Out
You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic …
book
Mastering VBA for Microsoft® Office 2010
A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) …