Introduction One of the most common operations when using VBA is to hide columns to declutter a worksheet. Maybe you have tons of data and all the information isn't necessary to show to the user. Maybe some of the data is intermediate data and all you want to show is the final results. This is […]

Introduction In this article we'll be going over the VBA Excel MOD operator or modulus operator. If you've never heard of modulus then you're in the perfect place. If you know what it is but aren't sure how to use it in VBA we'll show you how to do it. Let's jump right in! The […]

Introduction In this article we'll be discussing Excel VBA global variables, including what they are, how to declare them, and in what cases you'll utilize them. The prerequisites for this tutorial are very basic but check them out below. Prerequisites You should have a computer or a laptop with MS Excel installed and a basic […]

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 […]