Taylor's Library Banner
Image from Google Jackets

Excel VBA macro programming / Richard Shepherd.

By: Publication details: New York : McGraw-Hill/Osborne ; London : McGraw-Hill, c2004.Description: xv, 319 p. : ill. ; 24 cmISBN:
  • 0072231440
Subject(s): DDC classification:
  • 005.268 SHE
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.
Holdings
Cover image Item type Current library Home library Collection Shelving location Shelf location Call number Materials specified Vol info Copy number Status Notes Date due Barcode Item holds Item hold queue priority Course reserves
Main Collection Taylor's Library-TU

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

 005.268 SHE (Browse shelf(Opens below)) 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.