Excel VBA Macro Programming

Excel VBA Macro Programming
By:Shepherd, Richard;
Pub Date:February 4th 2004
Format:Paperback 320 pages
eBook Available: View eBook Details
ISBN:0072231440 / 9780072231441
Your Price:$34.00 ADD TO CART
More Information




Main description

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.


Table of 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


Backcover

Author Information

Downloads & Resources

Downloads



Related Products

Owl Image

Date: Oct 13th, 2014
Your Price: $50.00
Owl Image

Date: Nov 12th, 2012
Your Price: $70.00
Owl Image

Date: Oct 9th, 2012
Your Price: $50.00
Owl Image

Date: Aug 14th, 2012
Your Price: $50.00
Owl Image

Date: Feb 10th, 2012
Your Price: $50.00
Owl Image

Date: Jan 20th, 2012
Your Price: $137.00
Owl Image

Date: Dec 14th, 2011
Your Price: $50.00
Owl Image

Date: Aug 2nd, 2011
Your Price: $42.00
Owl Image

Date: Jul 13th, 2011
Your Price: $63.00
Owl Image

Date: Jan 31st, 2011
Your Price: $42.00
Owl Image

Date: Nov 24th, 2010
Your Price: $22.00
Owl Image

Date: Nov 15th, 2010
Your Price: $44.00
Owl Image

Date: Nov 5th, 2010
Your Price: $42.00
Owl Image

Date: Nov 4th, 2010
Your Price: $38.00
Owl Image

Date: Oct 28th, 2010
Your Price: $42.00