Power Spreadsheets

Excel VBA Events: Tutorial And List With 115 Application, Workbook, Worksheet And Chart Events

Once you've created a macro, you need a way to execute or call it. Otherwise, all of your work designing and coding the VBA application would've been in vain. Within Excel, you have several different options for calling or running a VBA Sub procedure. In fact, in this Excel VBA tutorial alone, I explain 9 different ways in which you can execute a Sub procedure. A very useful … [Read more...]

How To Convert PDF To Excel Using VBA: Tutorial + 4 Code Examples

[Some of the links in this Excel Tutorial are affiliate links, which means that if you choose to make a purchase, I will earn a commission. This commission comes at no additional cost to you.] I've written about the topic of PDF and Excel several times throughout Power Spreadsheets. Some of the issues I've covered include the following: How to convert PDF files to Excel. … [Read more...]

Excel VBA Array: The Complete Tutorial for Beginners

If you've been working with (or learning) Visual Basic for Applications, you're probably aware of the importance of having a solid knowledge of certain topics that influence data storage and manipulation. I've written detailed and comprehensive tutorials about several of these topics, including the following 2: Declare Variables In VBA For Excel: The How-To Guide. Excel … [Read more...]

Excel Goal Seek And The GoalSeek VBA Method: Introductory Tutorial With Examples

One of the most popular group of features in Excel are the What-If Analysis tools. In Microsoft's words, What-If Analysis tools allow you to "try out various values for the formulas in your sheet". This particular Excel tutorial focuses on 1 of these What-If Analysis tools: Goal Seek. Learning how to use Goal Seek is extremely helpful because, as I explain below, you can … [Read more...]

R1C1-Style Notation And The FormulaR1C1 Property In Excel VBA: Tutorial And Examples

If you've used the macro recorder, you're probably familiar with both R1C1-style notation and the FormulaR1C1 property. This is because, as explained at Stack Overflow, the macro recorder constantly uses FormulaR1C1. For example, even though you normally use the Range.Value property for purposes of entering a value in a cell, the macro recorder uses the Range.FormulaR1C1 … [Read more...]