My guest today is a force of nature in the speaking, consulting, training, healing, educating, and all around good person worlds. If there’s a useful therapeutic modality out there, I bet she knows its inner workings. And… she was my office mate in grad school where we both clawed a PhD out of the Univ […]

Introduction If you're just getting familiar with using VBA in your Excel spreadsheets then this article is perfect for you. This article shows some code samples for common use cases. Prerequisites Before starting to use VBA, you must first download and install the Microsoft Excel. You will also need to Enable VBA's Developer Tab in […]

Introduction In this article we'll go over some of the more common commands in the VBA command list. We'll also show you examples of each of the commands we go over. Please try these out on your own because it will help cement the concepts. The VBA command list Microsoft Excel uses several useful and […]

VBA empty Introduction In this article we will be talking about a method that let's you check whether a cell is empty. It also works for checking a range of cells. The method in VBA is the IsEmpty function and is one of the most commonly used functions to check for VBA empty cells. This […]

Introduction I am going to write an article explaining the guidelines and functions of the VBA excel offset. The VBA Excel Offset VBA Offset Function - in Excel is defined as a reference function. The function will return a specific cell. It will help us if we wanted to move from a certain cell to […]

keyword: vba excel open file dialog Introduction In this tutorial we'll cover how to create an VBA Excel open file dialog box. We'll use some basic examples so you can easily follow along. The VBA Excel Open File Dialog In VBA the Application.GetOpenFileName method allows you to choose a file you want to open. Let's […]

Introduction In this article we will be walking through how to add VBA Excel Buttons to improve your worksheets. The VBA Excel Button Button can make our lives easier by letting us choose certain text that we have in the list. We have different types of buttons namely: Shapes Button, Form Control Buttons, ActiveX Control […]

The VBA Excel Dictionary In Visual Basic for Applications, in the Dictionary function, we use arrays and collections in storing values needed in creating a macro code. For example, we can use it when storing the lists of colors name from a certain cell range in a worksheet. Dictionary is very much like collections and […]

Introduction The VBA Excel Autofilter let's us filter a range of cells in our worksheets with a desired order. Sorting is necessity in worksheets and we'll show you how to do it in this tutorial. The VBA Excel Autofilter Let's first take a look at some sample data: By using the code below, we can […]

Introduction In this article, we will be discussing the functions and the definitions of excel VBA wait. The Excel VBA Wait The Wait function is similar to a sleep function. VBA created a method to wait or pause for a period of time. The method that is being used in this function is the ****Application.Wait*** […]

Introduction In this tutorial we'll go demonstrate how to create an Excel VBA Listbox. Listboxes can make your worksheets more usable for your users and yourself. Let's jump right in! The Excel VBA Listbox A Listbox is another name for a dropdown where the user can select the value from a list of items. Steps […]

I'm thrilled to announce that I've been selected as a speaker at Pubcon 2025 in Austin! This is an incredible opportunity to share insights and engage with industry experts in the vibrant tech hub of Texas. With over 20 years of experience in SEO, PPC, CRO, and software development, I am eager to delve into […]