How to automate Goal Seek in Excel

How to automate Goal Seek in Excel

Goal Seek runs calculations repeatedly (iteratively) to find possible outcome values for your inputs. In this guide, we’re going to show you how to automate Goal Seek in Excel. Download Workbook Scenario Let’s take a look at a basic example. There are two inputs...
How to convert text to speech in Excel

How to convert text to speech in Excel

Excel has supported text-to-speech since 2003. In this guide, we’re going to show you how to convert text to speech in Excel using commands or VBA. Download Workbook Testing text to speech Follow the steps below to quickly test the text to speech functionality. Select...
How to get filename from path in Excel

How to get filename from path in Excel

In this guide, we’re going to show you how to get filename from path in Excel. We will cover how to do this with and without VBA. Download Workbook File path and file name A file path is a string identifier that specifies the unique location in a file system. It...
How to display File Open dialog in VBA

How to display File Open dialog in VBA

Excel VBA allows you to open a workbook directly – all you need is the full path of the file, including the file name. However, locating and supplying the file path each time may can be tedious when working with multiple files. In this guide, we’re going to show...
How to insert specific number of rows in Excel

How to insert specific number of rows in Excel

Inserting new rows is the easiest way to add new fields into your worksheet area. Since Excel inserts rows by copying the formatting of the previous row, it is usually more practical than moving bottom cells to open up space for new data. Thanks to VBA, we can insert...
How to shorten VBA code in Excel

How to shorten VBA code in Excel

How to shorten VBA code in Excel Shortening VBA code can make it much easier to read and maintain. Here, we mean shortening in the sense that some code blocks can be stacked or alternative statements can be introduced to make it more efficient. In this guide,...
5 tips for VBA beginners in Excel

5 tips for VBA beginners in Excel

In this guide, we’re going to show you 5 tips for VBA beginners in Excel and get you up to speed in no time! Saving macros – tips for VBA beginners Since the 2007 version, Excel has been differentiating between files containing macros based indicated by...