|
Excel VBA Macro Programming
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.
CONTENTS:
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
|
