Book description
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.
Explains step-by-step how to automate Excel, the world's leading spreadsheet application from Microsoft
Covers most tasks in two-page spreads -- no flipping back and forth required!
Teaches you over 130 tasks, including how to record macros, program in Visual Basic for Applications (VBA), debug code, automate charts, interface with other macros, automate functions -- all in an easy-to-follow visual format
Uses clear, step-by-step, numbered instruction and lots of graphics and screenshots -- perfect for visual learners!
Helps you maximize your productivity with practical examples, tips, and advice
Harness everything that Excel has to offer with this friendly, practical, visual guide.
Table of contents
- Copyright
- Credits
- About the Author
- Author's Acknowledgments
- How to Use This Visual Blueprint Book
-
1. Using Macros and Form Controls
- 1.1. Introducing Excel Programming
- 1.2. Introducing Macros
- 1.3. Set Macro Security
- 1.4. Create a Digital Signature
- 1.5. Record a Macro
- 1.6. Assign a Digital Signature to a Macro
- 1.7. Run a Macro
- 1.8. Create and Launch a Keyboard Shortcut
- 1.9. Assign a Macro to the Quick Access Toolbar
- 1.10. Delete a Macro
- 1.11. Add a Form Control to a Worksheet
- 1.12. Assign Values to a Form Control
- 1.13. Add a Macro to a Form Control
- 2. Using the Visual Basic Editor
- 3. Introducing Visual Basic for Applications
- 4. Introducing the Excel Object Model
- 5. Understanding Arrays
- 6. Controlling Program Flow
-
7. Using Excel Worksheet Functions
- 7.1. Work with Excel Worksheet Functions
- 7.2. Work with a MsgBox Function
- 7.3. Using the InputBox Function
- 7.4. Retrieve the Current Date and Time
- 7.5. Perform Date and Time Calculations
- 7.6. Format a Date Expression
- 7.7. Format a Numeric Expression
- 7.8. Change the Case of a String
- 7.9. Return a Portion of a String
- 8. Debugging Macros
- 9. Working with Workbooks and Files
- 10. Working with Worksheets
-
11. Defining Ranges
- 11.1. Using the Range Property
- 11.2. Using the Cells Property
- 11.3. Combine Multiple Ranges
- 11.4. Using the Offset Property
- 11.5. Delete a Range of Cells
- 11.6. Hide a Range of Cells
- 11.7. Create a Range Name
- 11.8. Resize a Range
- 11.9. Insert a Range
- 11.10. Set the Width of Columns in a Range
- 11.11. Set the Height of Rows in a Range
-
12. Working with Cells
- 12.1. Cut and Paste Ranges of Cells
- 12.2. Copy and Paste Ranges of Cells
- 12.3. Using Paste Special Options When Pasting
- 12.4. Add Comments to a Cell
- 12.5. Automatically Fill a Range of Cells
- 12.6. Copy a Range to Multiple Sheets
- 12.7. Add a Border
- 12.8. Find Specific Cell Values
- 12.9. Find and Replace Values in Cells
- 13. Working with Lists
-
14. Creating Dialog Boxes and Customizing the Ribbon
- 14.1. UserForm Basics
- 14.2. Create a Custom Dialog Box
- 14.3. Call a Custom Dialog Box from a Procedure
- 14.4. Capture Input from a Custom Dialog Box
- 14.5. Validate Input from a Dialog Box
- 14.6. Create Custom UserForm Controls
- 14.7. Create a UserForm Template
- 14.8. Customize the Ribbon
- 14.9. Create a CustomUI.xml File
- 14.10. Add a CustomUI.xml File to a Workbook
- 14.11. Add Additional Options to the Ribbon
- 15. Working with Charts
- 16. Working with PivotTables
-
17. Automating Procedures with Excel Events
- 17.1. Understanding Excel Events
- 17.2. Run a Procedure as a Workbook Opens
- 17.3. Run a Procedure before Closing a Workbook
- 17.4. Run a Procedure before Saving a Workbook
- 17.5. Run a Procedure When Excel Creates a Workbook
- 17.6. Execute a Procedure at a Specific Time
- 17.7. Execute a Procedure When You Press Keys
- 17.8. Monitor a Range of Cells for Changes
- 18. Building Add-Ins
- 19. Understanding XML
- A. VBA Quick Reference
Product information
- Title: Excel® Programming: Your visual blueprint™ for creating interactive spreadsheets
- Author(s):
- Release date: August 2010
- Publisher(s): Visual
- ISBN: 9780470591598
You might also like
book
Excel® 2007 VBA Programmer's Reference
Get ready to take your Excel applications to the next level by harnessing the power of …
book
Microsoft® Office Excel 2003 Programming Inside Out
Take your Microsoft Office experience to the next level by programming custom business solutions with Excel …
book
Professional Outlook® 2007 Programming
Written by one of the most popular and knowledgeable Microsoft Outlook MVPs, this book fills a …
book
Excel 2007 VBA Programming with XML and ASP
Excel 2007 Programming by Example with XML and ASP offers a hands-on approach for those looking …