Taylor's Library

Normal view MARC view ISBD view

Excel VBA macro programming / Richard Shepherd.

By: Shepherd, Richard.
Publisher: New York : London : McGraw-Hill/Osborne ; McGraw-Hill, c2004Description: xv, 319 p. : ill. ; 24 cm.ISBN: 0072231440.Subject(s): Microsoft Excel (Computer file) | Microsoft Visual BASIC | MacroprogrammingDDC classification: 005.268
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.
Item type Current location Shelf location Call number Copy number Status Notes Date due Barcode
Main Collection Taylor's Library-TU

Floor 3, Shelf 1 , Side 1, TierNo 6, BayNo 2

 005.268 SHE (Browse shelf) 1 Available SOCIT,15008,03,GR 5000039125

Includes index.

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.