Minecraft Adventures B2G1 Free

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | Today, 11:39am

    Sara Jaffe: IMG Summer Friction

    I was crying or almost crying for most of Fun Home: The Musical — I already loved Alison Bechdel's graphic novel, and I've always been a... Continue »
    1. $10.47 Sale Trade Paper add to wish list


      Sara Jaffe 9781941040133

Qualifying orders ship free.
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel VBA Macro Programming (Programming)


Excel VBA Macro Programming (Programming) Cover


Synopses & Reviews

Publisher Comments:

Develop powerful, custom Excel applications using Visual Basic for Applications Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you'll find complete details on Excel VBA programming and application development--from the fundamentals to advanced techniques. Then, you'll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components--and much more. Write and debug VBA code Create custom dialog boxes and toolbars Take advantage of the Excel object model Write code to interact with a database Use application programming interface (API) calls Create and use class modules Develop unique menus within the Excel menu structure Expand calculation and search functions Write macros for customized worksheets Create full-fledged Excel add-ins

Book News Annotation:

Shepherd, a software developer, shows power users how to maximize the features and functionality of Excel. He explains fundamentals and advanced techniques of Excel VBA programming and application development, then provides 21 real-world projects, complete with working code, so that readers can start creating Excel VBA macros right away. These projects include everything from setting up timed events to altering the appearance of spreadsheet components. Readers are assumed to have a working knowledge of Excel.
Annotation 2004 Book News, Inc., Portland, OR (booknews.com)

About the Author

Richard Shepherd has been developing software for blue-chip corporations for 20 years. He has produced VBA code in Excel for major projects, including profit-and-loss reporting and business planning and budgeting.

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

Product Details

Shepherd, Richard
McGraw-Hill/Osborne Media
Programming Languages - Visual BASIC
Spreadsheets - General
0073294527, 0073250368, 0073519219, 007160006X, 0-07-159958-4, 9780072263695, 9780072263725, 9780071497107, 9780072231441
Macro instructions (Electronic computers)
Visual Basic (Computer program language)
Personal Computers-Desktop Applications-Spreadsheets
Edition Number:
Publication Date:
January 2004
Grade Level:
Professional and scholarly
9.14x7.34x.77 in. 1.23 lbs.

Other books you might like

  1. Degunking Windows Used Trade Paper $1.48
  2. Real Fitness for Real Women: A... Used Trade Paper $7.50
  3. The 30-Minute Fitness Solution: A... Used Hardcover $9.95
  4. Degunking Your Mac New Trade Paper $24.99
  5. Landscaping with Stone Used Trade Paper $10.95
  6. The Scarith of Scornello: A Tale of... Used Hardcover $4.95

Related Subjects

Computers and Internet » Computer Languages » Visual Basic
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Computers and Internet » Software Engineering » Programming and Languages

Excel VBA Macro Programming (Programming) New Trade Paper
0 stars - 0 reviews
$32.00 In Stock
Product details 319 pages McGraw-Hill/Osborne Media - English 9780072231441 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.