O'Reilly logo

Programming Excel with VBA: A Practical Real-World Guide by Flavio Morgado

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Afterword

Writing this book was a great challenge for me: I had to learn Excel VBA programming as I wrote it because my first intention was to try every Excel feature using the VBA Immediate window. If it works in the VBA Immediate window, it surely works inside any VBA code procedure.

I had a slight notion about how each book chapter should proceed. Chapter 1 should make a brief introduction to the VBA integrated development environment (IDE) and the VBA language, with some simple examples about variable declarations, loop structures, and so on. The next three chapters should touch on the Excel object model from the top down: first the Applicationobject, then the Workbookobject , then the Worksheet object, and finally the Range object.

But how ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required