Shows how to build VBA macros to maximize the power of Excel. Follow more than twenty sample codes through projects that are practical and useful, and learn to apply VBA programming in unique and useful ways.
Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You'll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.
Part I: Programming in Excel VBA 1: The Basics 2: Variables, Arrays, Constants, and Data Types 3: Modules, Functions, and Subroutines 4: Programming Basics: Decisions and Looping 5: Strings and Functions and Message Boxes 6: Operators 7: Debugging 8: Errors and the Error Function 9: Dialogs 10: Common Dialog Control 11: Command Bars and Buttons Part II: Object Models 12: The Excel Object Model 13: The Excel Object Model-Main Objects 14: Using Excel to Interact with Other Office Programs Part III: Advanced Techniques in Excel VBA 15: Charts and Graphs 16: Working with Databases 17: API Calls 18: Class Modules 19: Animation Part IV: VBA in Action 20: Converting Labels to Numbers and Numbers to Labels 21: Transposing a Range of Cells 22: Adding Formula Details into Comments 23: Calculating a Range 24: Reversing a Label 25: Who Created the Workbook? 26: Evaluating a Cell 27: Sorting Worksheets into Alphabetical Order 28: Replacing Characters in a String 29: Timed Events 30: Auto Totaling a Matrix of Numbers 31: Absolute and Relative Formulas 32: Coloring Alternate Rows and Columns of the Spreadsheet 33: Coloring Cells Containing Formulas 34: Summing Cells by Reference to a Master Cell 35: Globally Changing a Range of Values 36: Displaying Hidden Sheets Without a Password 37: Searching Multiple Sheets and Workbooks 38: Brighten Up Your Comments 39: An Alternative to Message Boxes 40: Working with Shapes 41: Turning Your VBA Code into an Add-In A: ASCII Character Codes
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
Über den Autor
McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide
Inhaltsverzeichnis
Part I: Programming in Excel VBA
1: The Basics
2: Variables, Arrays, Constants, and Data Types
3: Modules, Functions, and Subroutines
4: Programming Basics: Decisions and Looping
5: Strings and Functions and Message Boxes
6: Operators
7: Debugging
8: Errors and the Error Function
9: Dialogs
10: Common Dialog Control
11: Command Bars and Buttons
Part II: Object Models
12: The Excel Object Model
13: The Excel Object Model-Main Objects
14: Using Excel to Interact with Other Office Programs
Part III: Advanced Techniques in Excel VBA
15: Charts and Graphs
16: Working with Databases
17: API Calls
18: Class Modules
19: Animation
Part IV: VBA in Action
20: Converting Labels to Numbers and Numbers to Labels
21: Transposing a Range of Cells
22: Adding Formula Details into Comments
23: Calculating a Range
24: Reversing a Label
25: Who Created the Workbook?
26: Evaluating a Cell
27: Sorting Worksheets into Alphabetical Order
28: Replacing Characters in a String
29: Timed Events
30: Auto Totaling a Matrix of Numbers
31: Absolute and Relative Formulas
32: Coloring Alternate Rows and Columns of the Spreadsheet
33: Coloring Cells Containing Formulas
34: Summing Cells by Reference to a Master Cell
35: Globally Changing a Range of Values
36: Displaying Hidden Sheets Without a Password
37: Searching Multiple Sheets and Workbooks
38: Brighten Up Your Comments
39: An Alternative to Message Boxes
40: Working with Shapes
41: Turning Your VBA Code into an Add-In
A: ASCII Character Codes
Klappentext
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Develop powerful, custom Excel applications using Visual Basic for Applications>Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you'll find complete details on Excel VBA programming and application development--from the fundamentals to advanced techniques. Then, you'll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components--and much more.
- Write and debug VBA code
- Create custom dialog boxes and toolbars
- Take advantage of the Excel object model
- Write code to interact with a database
- Use application programming interface (API) calls
- Create and use class modules
- Develop unique menus within the Excel menu structure
- Expand calculation and search functions
- Write macros for customized worksheets
- Create full-fledged Excel add-ins
>
