In this part of the Power Query series, we will be taking a quick look at the Close & Load options. So far, we have only used the default option which loads the output of the query into a new worksheet. But there are plenty of other options we could use instead. We won’t get Read More
Category: Blog
Power Query – Edit Queries
In this part of the Power Query series, we will look at how to edit queries. We’ve seen a small piece of this in a previous post, but now we’ll go a lot deeper. Download the example files It may be tempting to just read the text below, but you will retain the information much Read More
Power Query – Data Refresh
In the previous part of this Power Query series, we took a first look at how to import data from various file formats and load it into Excel. Now, in this part, we move on to consider how we can refresh the data, which enables us to build a query once and use it over Read More
Power Query – Importing Data
OK, Let’s get started with Power Query. The first thing we need to do is import some data. As this is our first real look at Power Query, we are going to use this as an opportunity to explore the user interface. This post is structured into two parts: Using data in the same workbook Read More
Power Query – Introduction
The party would already be in full swing; I was going to be late. Not fashionably late, just late. When I finally arrived, rather than the usual “What time do you call this?“, I received the “Hey; you made it, that’s amazing. It’s great you could come. Let me show you around“. Nobody looked down Read More
Loop through each item in a Data Validation list with VBA
I had an interesting question from a reader recently. He wanted to save a PDF for each item in a data validation drop-down list. In the past, when I have tackled similar tasks, I have always used a named range with all the possible values, then looped through the cells in the named range. My Read More
VBA code for charts and graphs in Excel
Charts and graphs in Excel have hundreds of different options. This is great for creating precisely the visualization we want but can be time-consuming to apply. When we want to apply those hundreds of settings to lots of charts, it can take hours and hours of frustrating clicking. The short code snippets below will help Read More
Resize a UserForm with VBA or Windows API
When creating a VBA UserForm, we generally set it to a specific size. Most other forms and windows within the Excel and Windows environments do not have a fixed sized; they can be resized by the user. With a bit of coding magic, we can achieve a similar resizing effect for our VBA UserForms. This Read More
![Hide or disable a VBA UserForm [X] close button](https://exceloffthegrid.com/wp-content/uploads/2019/04/Hide-or-Disable-UserForm-Close-Button.png)
Hide or disable a VBA UserForm [X] close button
While working on a project recently, I thought about hiding the [X] close button which is at the top of the VBA UserForm. I managed to identify three options for achieving this. If you are thinking about the same thing, then this post will give you the answers you’re looking for. To hide, or not Read More
Closing VBA UserForms: Hide vs Unload
VBA UserForms are a key tool for managing user interactions. When a UserForm is well designed, it guides the user through the options and settings without any help file or guidance. From my own UserForm development, I know one of the most overlooked aspects is the closure of the UserForm itself. This post will cover Read More