Excel VBA Macro Programming

2.89 avg rating
( 9 ratings by GoodReads )
 
9780072231441: Excel VBA Macro Programming

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.

"synopsis" may belong to another edition of this title.

From the Back Cover:

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.

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

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Shepherd, Richard
Published by McGraw-Hill Osborne Media (2004)
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2004. Paperback. Book Condition: New. book. Bookseller Inventory # 0072231440

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 19.63
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Shepherd, Richard
Published by McGraw-Hill Osborne Media (2004)
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Softcover Quantity Available: 1
Seller
Book Deals
(Lewiston, NY, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2004. Book Condition: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: 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. Bookseller Inventory # ABE_book_new_0072231440

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.55
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

3.

Shepherd, Richard
Published by McGraw-Hill Education - Europe, United States (2004)
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Paperback Quantity Available: 10
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2004. Paperback. Book Condition: New. 231 x 188 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AA39780072231441

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 21.57
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Shepherd, Richard
Published by McGraw-Hill Education - Europe, United States (2004)
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Paperback Quantity Available: 10
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2004. Paperback. Book Condition: New. 231 x 188 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AA39780072231441

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 22.35
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

5.

Shepherd, Richard
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Quantity Available: 5
International Edition
Seller
Bookshub
(Karol Bagh, India)
Rating
[?]

Book Description Book Condition: New. New. SoftCover International edition. Different ISBN and Cover image but contents are same as US edition.Perfect condition. Ship by express service to USA, Canada, Australia, France, Italy, UK, Germany and Netherland. Customer satisfaction our priority. Bookseller Inventory # ABE-190516-1247

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 23.10
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

6.

Shepherd, Richard
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Quantity Available: 5
International Edition
Seller
EBOOKSTORE2010
(New Delhi, ND, India)
Rating
[?]

Book Description Book Condition: Brand New. New. SoftCover International edition. Different ISBN and Cover image but contents are same as US edition. Customer Satisfaction guaranteed!!. Bookseller Inventory # SHAK1247

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 23.15
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

7.

Shepherd, Richard
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Quantity Available: 5
International Edition
Seller
firstbookstore
(New Delhi, India)
Rating
[?]

Book Description Book Condition: Brand New. Brand New Paperback International Edition, Perfect Condition. Printed in English. Excellent Quality, Service and customer satisfaction guaranteed!. Bookseller Inventory # AIND-38816

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 25.93
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds

8.

Shepherd, Richard
Published by McGraw-Hill Education (2004)
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Quantity Available: > 20
Print on Demand
Seller
PBShop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2004. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780072231441

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 22.57
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

9.

Shepherd, Richard
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Paperback First Edition Quantity Available: 1
Seller
Grand Eagle Retail
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description 2004. Paperback. Book Condition: New. 1st. 186mm x 20mm x 232mm. Paperback. This text was written for Power users who want to maximize the power of Excel by using VBA programmes to create time and effort saving macros. It should allow users to do basic programming.Shipping may be from multiple locations in the US or from the UK, depending on stock availability. 319 pages. 0.558. Bookseller Inventory # 9780072231441

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.07
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

10.

Shepherd, Richard
Published by McGraw-Hill Education (2004)
ISBN 10: 0072231440 ISBN 13: 9780072231441
New Quantity Available: 12
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education, 2004. PAP. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # CM-9780072231441

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 17.04
Convert Currency

Add to Basket

Shipping: US$ 11.14
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book