Buy Used
CDN$ 0.77
+ CDN$ 6.49 shipping
Used: Very Good | Details
Condition: Used: Very Good
Comment: This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See more of our deals.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Master Visually Excel 2003 VBA Programming Paperback – Feb 18 2005

4.0 out of 5 stars 1 customer review

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 37.53 CDN$ 0.77

Harry Potter and the Cursed Child
click to open popover

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Product Details

  • Paperback: 432 pages
  • Publisher: Visual; 1 edition (Feb. 18 2005)
  • Language: English
  • ISBN-10: 0764579738
  • ISBN-13: 978-0764579738
  • Product Dimensions: 20.5 x 2.9 x 23 cm
  • Shipping Weight: 880 g
  • Average Customer Review: 4.0 out of 5 stars 1 customer review
  • Amazon Bestsellers Rank: #511,776 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From the Back Cover

"One picture is worth a thousand words." If you prefer instructions that show you how rather than tell you why, then this intermediate to advanced level reference is for you. Hundreds of succinctly captioned, step-by-step screen shots reveal how to accomplish more than 180 Excel tasks with VBA programming, including:

  • Writing and recording short macros
  • Using all the VBA commands
  • Automating charts, pivot tables, and more
  • Adding digital signatures
  • Debugging your code
  • Specifying page setup settings
  • Writing a function procedure

About the Author

Julia Kelly is a writer, teacher, and consultant for desktop applications, including Excel, Access, Word, Publisher, and Outlook. She’s taught classroom courses in Excel at major corporations and Outlook courses on-line for several years, and has authored 17 book on Office applications. In addition, she develops Excel and Access applications for business clients.

Customer Reviews

4.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
Because i learn faster visually books from Master Visually are perfect for me.
The step-by-step screen shots help me a lot to understand the writing, recording and debugging macros.
This is a great book.
Camille Grenier
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse

Most Helpful Customer Reviews on (beta) HASH(0xa1906cb4) out of 5 stars 12 reviews
21 of 22 people found the following review helpful
HASH(0xa18b6714) out of 5 stars The best reference out there! March 9 2005
By Robert G. - Published on
Format: Paperback
I work in a corporate environment and have found this book to be invaluable -- even in the short two week's I've owned it. Hardly a day goes by when I don't need to find a little VBA technique to help me create useful Excel apps for our team, and this book thus far has not let me down. It's accessible, targeted and concise. Highly recommended.
11 of 11 people found the following review helpful
HASH(0xa18b6768) out of 5 stars Get THIS ONE FIRST June 9 2006
By B. Nicholson - Published on
Format: Paperback Verified Purchase
If there is one thing I know about trying to learn any computer program, it is that you have to get over the fear of the unknown and try it out to see how it works. This book gives you the exact keystrokes to use and pictures of what you should get step by step.

I've tried almost all of the routines and found very few errors. After going through this book you will be familiar with the syntax of VBA, how it is structured and see how it manipulates your spreadsheets in very practical ways that you can use today. You will find yourself keeping these small routines and copying them around in your larger more complex routines.

My only complaint is that sometimes it is hard to read the difference between a period and a comma. As you grow to learn VBA, this complaint lessens however. This is a minor complaint, and certainly not enough to recommend this book less.

I also own VBA Power Programming by Walkenbach, that book, will come ALIVE after you try all the procedures in THIS book.
11 of 12 people found the following review helpful
HASH(0xa18b6a44) out of 5 stars beginners should have this book Aug. 27 2006
By C. Johnson - Published on
Format: Paperback
This book takes you from recording macros to knowing what the Visual Basic editor is, which is the foundation of writing your own macors. The book explores all the basics that you need to grasp along with providing all the steps visually. There are pictures on each page. It shows how to reference workbooks, sheets, ranges, colunms and row statements along with how to make decisions using If Then Else and how to use Loops. Additional topics are charts, pivot tables and user forms. Check out the table of contents for a more information on topics covered.

The reason I gave it only 4 stars instead of 5 is that nowhere in the title or elsewhere does it state its a beginner book. With a title VBA Programming I expected indepth coverage of programming with the excel objects. I was looking more for a intermediate or advanced book.
6 of 6 people found the following review helpful
HASH(0xa18b6f60) out of 5 stars A welcome edition to my reference library. Feb. 2 2007
By Ted Calbazana - Published on
Format: Paperback
I've always been a fan of the Master Visually series by Wiley Publishers. I have seen many technical books attempt to use a Visual Graphis style to make complex ideas simple and easy to understand. In this edition of "Excel 2003 VBA Programming" authored by Julia Kelly I wasn't disappointed. I give this book such a high rating because it does exactly what it promises in terms of functionality and understanding.

There's a bit of the cookbook style to the Layout. In the Table of Contents Macro's are grouped by subject from simple to more complex. Of course it doesn't end there. The same technique is used to explore the Visual Basic Editor, Manipulating Worksheets and Workbooks, Working with Ranges, Looping and Branching, Charts and Pivot Tables. In higher order references the book gets into controlling Macros with Events and Form based Programmed Controls. The book also provides an orderly approach to teaching VBA programming and debugging with VBA IDE Interface which I find highly lucid.

The book seems determined on achieving maximum functionality and usefulness to its programmer's audience.

Please note that the fact that this book is written for Microsoft Office 2003 doesn't take away from its value when say compared to a Microsoft Office 2007 environment. Because of the inherent underlying Document Object Model used in Office products most of the functionality still applies.

Overall I would say this book has pretty much everything a new or experienced VBA Macro programmer needs to get busy and productive in a hurry. By the way, one of the nicer things about this book is its use of the sidebar on many of its examples. These sidebars attempt to offer shortcuts and address users issues in Question and Answer format.

In Short this is a book I would pleased to have in my reference library.
2 of 2 people found the following review helpful
HASH(0xa18b6f78) out of 5 stars Decent Beginners Book July 23 2009
By Erik Hoffman - Published on
Format: Paperback
I would consider myself an intermediate VBA user, reading a few books and developing a few applications. I didn't feel like I started to get anything out of this book until about 250 pages in, which is more than halfway through.

If you are an intermediate user I recommend Excel 2003 Power Programming with VBA by Walkenbach, or Excel 2003 VBA Programming with XML and ASP by Julitta Korol.

If you are a beginner then this book or the Dummies book by Walkenbach is a good place to start. This book feels more like a reference book, since they only focus on quick snippets of information at any one time. Two pages are dedicated to each topic. Here are some sample topics: Execute a task with a do while loop, ask a question with a message box, synchronize two charts, add a series trendline, declare a constant, etc.

For $15 this is a good buy just for reference, and maybe $20, but $25 seems a little steep considering the level of depth that goes into each topic. It just feels lacking as a whole, but the short concise approach may be good for an absolute beginner.