Writing Excel Macros with VBA: Learning to Program the Excel Object Model Using VBA

I want to learn how to program using VBA. The author seems to constantly imply what a great programmer he is and that you as a new or intermediate user of VBA do not need any examples of VBA code to learn the language.

Mr Roman is an extremely competent and clear writer. This book, whilst not as big as some, doesn't waste space with any padding, and boring repititious stuff you see in some texts.Although there could have been a little more on interplay between Excel and the other Office objects, esp. Outlook, this book makes up for that with its clear, organised and logical presenatation.I use it as a reference book, and seem to remember the content of it more clearly than I do with other comparable books! Why is this? Mr Roman has a tidy turn of phrase, doesn't wafffle, but his explanations seem to sit well in how my mind works. I hope this will be the same for you. I recommend this book for those who may be beyond the beginner stage of learning VB(A). It also includes some handy utilities for users of Excel.Mr Roman - well done. Look forward to your next (high level?) Excel VBA book.

There are a number books on VBA and on programming Excel with VBA. Some of these are quite good and have many useful examples. However, once one understands the basic techniques, accomplishing one's goal primarily requires detailed knowledge of the Excel object model. One can dig through the object browser and/or the Microsoft documentation for this information or use the macro recorder as a 'prototyping' shortcut, but these techniques are somewhat time consuming and are less than complete.This book's coverage of the Excel object model is by the far the best I have seen and is well organized and through. It explains the intent of the properties and methods rather than just explaining the syntax.The author also details various caveats about how various components within the object model operate. This is very useful. As a simple example, he explains that setting the Chart objects .HasAxis property before the Chart has any data series defined will result in a cryptic error that is not covered in the documentation. Without this information one might end up blindly copying some ugly code from the macro recorder that seems to work though it wouldn't be clear just why this code worked while the other method failed.If one is not already very knowledgeable of Excel and VBA, this book would probably work best accompanied by a book like Walkenbach's, "Excel 2003 Power Programming with VBA". Eventually however, this will probably become the "goto" reference.

The author states that he doesn't mince words or beat around the bush with certain concepts, and he proves to be a man of his word. This is probably more appropriate for macro writers with a little experience. If you're new to programming, you're probably better off in the world of Mr. Walkenbach, who understands that people are either new to programming or under a time cruch, and that sometimes a few explicit examples or extra explanation is appropriate. I own both authors and use both regularly. All in all, a solid reference for the right audience.

This book is kind of old and I believe there should be a lot better tutorials in this area. However, it is cheap and affordable. The paper quality and layout are poor and papers may get detach from the book cover easily.

Very good, lil on rambly side but explained well.

Seems outdated, but works perfectly in my excel 2016. Remember that vba its not like C++ or even Python, it doesn't change as much.

A few annoying typos, but nothing major. Meet my needs and expectations. Showed me how do things I was wondering about with clear explanations.

I enjoyed this book for learning more about VBA

Very good

This is the book you need if you are new to VBA.. OR even if you have a fair amount of knowledge in the subject!