Dynamic arrays and VBA user defined functions (UDFs)

Dynamic arrays & UDFs - Featured Image

Office 365 subscribers now have Excel’s new calculation engine available to them, meaning lots of users suddenly have access to dynamic arrays.  This got me thinking about whether VBA user-defined functions (UDFs) can make use of the new functionality too. I’m not an expert in this; I’m just sharing as much as I’ve learned to … Read more

VBA Arrays

VBA Code Snippets

Before I start, let me share a little secret with you… I really dislike VBA arrays.  There just seem to be too many oddities in how they work.  Compared with other programming languages, VBA seems to make arrays overly complicated.  If you feel the same, then you’re in the right place.  This post contains a … Read more

Remove blank rows in Excel

Remove blank rows - Featured Image

Data comes in all shapes, sizes and forms, so it’s not uncommon to find a dataset with a lot of blank rows.  Sometimes it’s not an issue; other times, it causes big problems.  Therefore, the best practice in Excel, is to remove blank rows.  If there are only a few blanks, we could do this … Read more

Resize a UserForm with VBA or Windows API

Resize UserForm VBA 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

Hide or Disable UserForm 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. Download the example file: Join … Read more