Murakami Sale
 
 

Recently Viewed clear list


Original Essays | August 18, 2014

Ian Leslie: IMG Empathic Curiosity



Today, we wonder anxiously if digital media is changing our brains. But if there's any time in history when our mental operations changed... Continue »
  1. $18.89 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$32.00
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)

by

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

ISBN:
9780072231441
Author:
Shepherd, Richard
Publisher:
McGraw-Hill/Osborne Media
Subject:
Programming Languages - Visual BASIC
Subject:
Spreadsheets - General
Subject:
Macroprogramming
Subject:
0073294527, 0073250368, 0073519219, 007160006X, 0-07-159958-4, 9780072263695, 9780072263725, 9780071497107, 9780072231441
Subject:
Macro instructions (Electronic computers)
Subject:
Visual Basic (Computer program language)
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Copyright:
Edition Number:
1
Series:
Programming
Publication Date:
January 2004
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
319
Dimensions:
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 Used Trade Paper $5.95
  5. Landscaping with Stone Used Trade Paper $8.95
  6. Yoga Builds Bones Rev Updated Edition Used Trade Paper $9.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:
spacer
spacer
  • back to top
Follow us on...




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.