What is the first thing that comes to your mind when thinking about Excel? In my case, it's probably cells. After all, most of the time we spend working with Excel, we’re working with cells. Therefore, it makes sense that, when using Visual Basic for Applications for purposes of becoming more efficient users of Excel, one of the topics we must learn is how to work with cells … [Read more...]
Excel VBA Data Types: The Complete Guide To 15 Important Data Types
Have you ever thought about the main purpose of Visual Basic for Applications? In Excel VBA Programming for Dummies, Excel authority John Walkenbach provides the following interesting answer to this question: VBA's main purpose is to manipulate data. For purposes of this VBA tutorial, the key term within the above statement is “data”. If the main purpose of Visual Basic for … [Read more...]
Excel VBA Sub Procedures: The Complete Tutorial
If you've read other Excel tutorials covering the topics of macros and Visual Basic for Applications, you've probably seen the term procedure mentioned several times. If you're only beginning to read about these topics, you'll probably see this term in the near future. And there are good reasons for this: If you want to become a powerful macro and VBA user, you must … [Read more...]
Excel VBA Object Model And Object References: The Essential Guide
If you've read any of the other macro or VBA tutorials in Power Spreadsheets, you've probably noticed that some terms keep popping up over and over. One of the concepts that keep coming up, and will continue to come up in future tutorials, is that of objects. The main reason for this is simple: VBA is (loosely) based on Object Oriented Programming. At a basic level, this … [Read more...]
Excel Visual Basic (VBA) Editor: The Complete And Easy Guide To The VBE
What is the aspect about learning macros and Visual Basic for Applications that you find more intimidating? For some people, the answer will revolve around having to learn a new programming language and coding. However, if you're anything like me, your answer will be the Visual Basic Editor (or VBE). The first few times I opened the Visual Basic Editor I had no idea what I … [Read more...]