Excel VBA Macro Programming

( 2 )

Overview

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 ...

See more details below
Paperback
$23.99
BN.com price
(Save 25%)$32.00 List Price
Other sellers (Paperback)
  • All (13) from $17.95   
  • New (7) from $22.40   
  • Used (6) from $17.95   
Sending request ...

Overview

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

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.

Read More Show Less

Product Details

  • ISBN-13: 9780072231441
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 1/14/2004
  • Series: In-Depth Programming and Web Development Series
  • Edition number: 1
  • Pages: 320
  • Sales rank: 323,776
  • Product dimensions: 7.40 (w) x 9.20 (h) x 0.69 (d)

Meet the Author

Richard Shepherd (Reading, Berkshire, England) is a qualified accountant with a special interest in computer languages, particularly Visual Basic, and he’s spent the last 20 years developing computer software in blue chip organizations.

Read More Show Less

Table of Contents

Ch. 1 The basics 3
Ch. 2 Variables, arrays, constants, and data types 11
Ch. 3 Modules, functions, and subroutines 25
Ch. 4 Programming basics : decisions and looping 33
Ch. 5 Strings and functions and message boxes 43
Ch. 6 Operators 67
Ch. 7 Debugging 77
Ch. 8 Errors and the error function 87
Ch. 9 Dialogs 91
Ch. 10 Common dialog control 107
Ch. 11 Command bars and buttons 117
Ch. 12 The Excel object model 125
Ch. 13 The Excel object model - main objects 141
Ch. 14 Using Excel to interact with other office programs 161
Ch. 15 Charts and graphs 171
Ch. 16 Working with databases 177
Ch. 17 API calls 183
Ch. 18 Class modules 193
Ch. 19 Animation 199
Ch. 20 Converting labels to numbers and numbers to labels 205
Ch. 21 Transposing a range of cells 209
Ch. 22 Adding formula details into comments 213
Ch. 23 Calculating a range 217
Ch. 24 Reversing a label 219
Ch. 25 Who created the workbook? 221
Ch. 26 Evaluating a cell 225
Ch. 27 Sorting worksheets into alphabetical order 229
Ch. 28 Replacing characters in a string 231
Ch. 29 Timed events 235
Ch. 30 Auto totaling a matrix of numbers 237
Ch. 31 Absolute and relative formulas 241
Ch. 32 Coloring alternate rows and columns of the spreadsheet 245
Ch. 33 Coloring cells containing formulas 251
Ch. 34 Summing cells by reference to a master cell 255
Ch. 35 Globally changing a range of values 259
Ch. 36 Displaying hidden sheets without a password 263
Ch. 37 Searching multiple sheets and workbooks 269
Ch. 38 Brighten up your comments 277
Ch. 39 An alternative to message boxes 287
Ch. 40 Working with shapes 291
Ch. 41 Turning your VBA code into an add-in 295
App. A ASCII character codes 303
Read More Show Less

Customer Reviews

Average Rating 4
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(1)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted October 31, 2004

    An excellent book

    An excellent book. This has opened up a whole new dimension to Excel and shown me how to write very effective code. Following the book, I have even created my own professional add in. I was amazed how well it works - my friends are very impressed! Plenty of examples to follow and copy in which all work. They go from easy to complicated e.g. adding row and column totals onto a selected matrix of numbers with a single click. The book is easy to follow and is well written.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 6, 2009

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)