Excel VBA Macro Programming

€ 32,99
Lieferbar innert 2 Wochen
Februar 2004



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
EAN: 9780072231441
ISBN: 0072231440
Untertitel: 'Programming'. Sprache: Englisch.
Erscheinungsdatum: Februar 2004
Seitenanzahl: 319 Seiten
Format: kartoniert
Es gibt zu diesem Artikel noch keine Bewertungen.Kundenbewertung schreiben