If you've used Excel in the past, you're likely familiar with worksheet functions. After all, most Excel users work with Excel worksheet functions (for ex., when creating worksheet formulas). In this particular Excel tutorial, I focus on how you can use your knowledge of Excel worksheet functions when working with VBA. Yes! You can use worksheet functions when writing VBA … [Read more...]
VBA Methods: The Complete Guide To Working With Methods In Excel
If you're in the process of learning Visual Basic for Applications, there are a few basic topics you need to thoroughly understand. I have explained some of these in other blog posts that you can find at the Power Spreadsheets Archive. However, at the most basic level, the following 3 topics are perhaps the most basic things you need to learn and understand in order to start … [Read more...]
Excel VBA Object Properties: How To Work With, And Get, Available Properties
I've got to confess something to you: I cover the topic of VBA objects extensively in Power Spreadsheets, including here and here. However, when working in Visual Basic for Applications, you can't really do anything meaningful by knowing only what I explain in those Excel tutorials. Let me explain what I mean: There is no doubt that the concept of objects is central to VBA. … [Read more...]
Define Variables In VBA: How To Declare Variables And Assign Them Expressions
One of the main objectives of VBA and (more generally) Excel is to work with (and manipulate) data. This data is generally stored in the computer's memory. For purposes of this Excel guide, we'll distinguish between the following 2 places to store data: Objects. Variables. The former topic (objects) is covered in other Excel tutorials within Power Spreadsheets, including … [Read more...]
Excel VBA Function Procedures: Easily Create And Execute User-Defined Functions (UDFs)
One of the most commonly used features in Excel are its functions. This is hardly surprising. After all, Excel has hundreds of built-in functions. The variety, in terms of uses and complexity, is quite remarkable. Excel seems to have a function for everything. But… Is this really the case? And… Even assuming that there is a function for everything, is relying solely on … [Read more...]