Get Digital Help
  • Home
  • Templates
  • Products
  • Functions
  • Archive
  • Contact
  • About Me
    • About me
    • Blogs I read
    Function Reference Formulas Charts Conditional Formatting Excel Tables Pivot Tables VBA Knowledge Base Macros User Defined Functions Videos Advanced Excel Course

    Most used functions

    COUNTIF function INDEX function IF function SUM function SUMIFS function SUMPRODUCT function VLOOKUP function


Archive for Macro


Four ways to resize a chart

To be able to resize a chart you must first select it, you do that by left-click on the chart with […]

How to quickly select blank cells

In this smaller example, column D (Category) has empty cells, shown in the picture above. If your column contains thousands of […]

How to add a macro to your Excel Quick Access Toolbar

The Quick Access Toolbar is located at the very top of your Excel window, I highly recommend that you place your […]

Opening a workbook runs a macro automatically

This article explains how to set up a workbook so a macro is executed every time you open the workbook. […]

How to use DIALOG BOXES

A dialog box is an excellent alternative to a userform, they are built-in to vba and can save you time because […]

Find the longest/smallest consecutive sequence of a value [VBA]

This post Find the longest/smallest consecutive sequence of a value has a few really big array formulas. Today I would like to show […]

List comments [VBA]

Did you know that you can select all comments in the current sheet? Press F5, click "Special..." button, select "Comments" […]

Copy filtered Excel tables [VBA]

Today I want to share some pretty useful macros. My first macro copies an excel defined table with vba. It is […]

Remove print preview lines (Page Breaks)

Have you ever wondered how these lines got there on a worksheet? They show where pages will break, in other […]

Working with TEXT BOXES [VBA]

Excel allows you to insert text boxes on a sheet. There are two kinds of text boxes. Form controls and […]

Show and hide a picture [VBA]

Have you ever seen dashboards where you can click a shape and a picture shows up. If you click it […]

Click a button to make specific worksheets hidden or visible (vba)

Click button "Show / Hide worksheets" to show or hide worksheets entered in cell range B6:B7. Instructions Here is how […]

Click a cell to make a column hidden or visible [VBA]

Click a single cell in column D to hide or show the comments in column E. Selecting multiple cells won´t […]

Scroll through a data set [VBA]

Sometimes you just want to show a small section of your data set, like in a dashboard or a chart. […]

Highlight date ranges overlapping selected record [VBA]

The following example shows you how to highlight overlapping ranges. How it works Select a date in the table. Conditional […]

Count text strings in formulas [VBA]

Rahul Jadhav asks: I have many excel files with multiple sheets and each excel sheet has many formula which are […]

COPY RENAME LIST FILES

In this blog article I will demonstrate file copying techniques using excel visual basic for applications. The code below is […]

Change picture [VBA]

Rahul asks: i want to know that when we create a vlookup sheet, and in the name column we enter […]

Move a shape [VBA]

This post shows you how to move a shape with vba code. Select a cell (button name) and the arrow […]

Run a Macro from a Drop Down list [VBA]

This article demonstrates how to execute a VBA macro using a drop down list. The drop down list contains multiple […]

Hide specific columns [VBA]

Cyril asks how to hide all columns of a range except columns whose header is found in specific cells. I am […]

Change bar color in charts [VBA]

Peter asks: Hello, I’m new working with dynamic charts using Excel 2007. I created a dynamic bar chart using 2 […]

Copy excel table filter criteria [VBA]

Here is how to copy filter criteria from an excel table and use the same table filters on another table. […]

Excel calendar [VBA]

This calendar lets you schedule events on the data sheet. Select a cell (calendar date) and events on that day […]

Use filtered table values in a drop down list [VBA]

I read a very interesting blog post about Using Custom Functions in Dynamic Ranges Gabhan Berry creates a user defined […]

Sort values in a cell using a custom delimiter [VBA]

The following macro lets you select a cell range and a delimiting character. The macro sorts the values in each […]

Quickly create new sheets [VBA]

The following macro let´s you select a cell range and then the macro creates sheets with the same names as […]

Interactive Excel chart [VBA]

I found a basic interactive chart on the chitika website and my first thought was if I could do this […]

Sort values in an Excel table [VBA]

awall asks: Hey can you do the opposite of this - not random order but this is my situation. i […]

Search two related tables simultaneously [VBA]

Let´s say you do a lot of searches in two tables. The tables are related so it would be great […]

Select a cell in a table and the chart updates automatically [VBA]

The following vba code makes it possible to automatically update a chart when you click a cell in a table. […]

Excel template: Getting Things Done [VBA]

In this blog post I am going to demonstrate a simple workbook where you can create or delete projects and […]

Normalize data [VBA]

Debra has a great post and video about normalizing data for excel pivot table. This post describes a macro that normalizes […]

Add values to different sheets [VBA]

Phil asks: Could you please show me the code to place the copied data into a different tab instead of […]

Add values to a table [VBA]

Cyril asks: I do remember seeing one nice way of populating a table with the use of vba such as […]

Open Excel files in a folder [VBA]

This tutorial shows you how to list excel files in a specified folder and create adjacent checkboxes, using vba. The […]

Copy table design settings [VBA]

The macro provided in this blog post let´s you copy table design settings to other tables in the same workbook. […]

Toggle a macro on/off using a button

This post demonstrates using a single button (form control) to turn a macro on or off. VBA Macro I am […]

Automate data entry [VBA]

In some cases it can be useful and timesaving to automate data entering. The vba examples here all enter a […]

Apply data validation lists dynamically [VBA]

Table of Contents Applying Drop Down lists dynamically using an Excel Defined table Applying Drop Down lists dynamically (vba) Add […]

Workbook log [VBA]

This post demonstrates how to automatically create log entries when a workbook opens or closes. VBA code Where to copy […]

Categorize data entry values [VBA]

In a previous post I described how to simplifiy data entry. Now it is time to put values in separate […]

Copy a cell range whose size is likely to change from time to time [VBA]

In this blog post I will demonstrate some vba copying techniques. Example 1, This example code copies cell range A1:B2 […]

List all open workbooks and corresponding sheets [VBA]

In this post I am going to demonstrate how to create a new sheet in the current workbook and list […]

Basic data entry [VBA]

In this small tutorial I am going to show you how to create basic data entry with a small amount […]

List all tables and corresponding headers in a workbook [VBA]

This macro creates a new sheet and lists all tables and corresponding table headers in a workbook. Example Sheet1, 2 […]

Working with COMBO BOXES [Form Controls]

This blog post demonstrates how to create, populate and change comboboxes (form control) programmatically. Form controls are not as flexible […]

Change chart data range using a Drop Down List [VBA]

This blog post demonstrates how to quickly change chart data range. I have created a drop down list (form control) […]

Filter an Excel table using the selection change event [VBA]

In this post I am going to demonstrate how to quickly apply a filter to a table. I am using […]

Populate a combobox with values from a pivot table [VBA]

In this post I am going to demonstrate two things: How to fill a combox with table headers Populate a […]

Add checkboxes to a sheet (1/2) [VBA]

In this post I will demonstrate how to create checkboxes in nonempty rows. VBA code   Where to copy vba […]

Add values to a data validation list [VBA]

In this tutorial I am going to show you how to create a drop down list (data validation) in cell […]

Populate a list box with visible unique values from an Excel table [VBA]

Excel tables, introduced in excel 2007, sort, filter and organize data any way you like. You can also format data […]

Populate a combo box (form control) [VBA]

In this tutorial I am going to explain how to: Create a combo box (form control) Filter unique values and […]

Create a custom-made item on the shortcut menu [VBA]

This post describes how to add a new custom-built item to the shortcut menu in excel 2007. In excel 2007 […]

Select cell A1 on all sheets before you close a workbook [VBA]

This post demonstrates how to automatically select cell A1 on each sheet in a workbook before you close a workbook. […]

Use text qualifiers to make text to columns conversion easier [VBA]

This blog post describes how to create text qualifers and make "text to columns" conversion easier. Example I copied a […]

Create a Print button [VBA]

This article describes how to create a button and place it on an Excel worksheet. Then assign a macro to […]

Select and view invoice [VBA]

A previous post described how to create a listbox filled with unique invoice numbers: Excel vba: Populate listbox with unique invoice […]

Populate listbox with unique invoice numbers [VBA]

This post describes how to fill a listbox with unique values. Create button (Form Control) Select sheet "Invoice" Click "Developer […]

Edit invoice data [VBA]

In a previos post:Excel vba: Save invoice data we added/copied data between sheets. This post describes how to overwrite existing […]

Save invoice data [VBA]

This post describes how to copy values between sheets. I am using the invoice template sheet. This macro copies rows […]

Select value based on time and date [VBA]

Introduction This blog post describes how to automatically select a value based on time and date using vba in excel. […]

How to quickly select a non contiguous range

A non-contiguous list is a list with occasional blank cells and that makes it harder to select the entire cell […]

Consolidate sheets [vba]

Question: I have multiple worksheets in a workbook. Each worksheets is project specific. Each worksheet contains almost identical format. The […]

Categorize values into multiple columns [VBA]

I am fairly new to vba and I am amazed of how much you can automate in excel. In this […]

Split data across multiple sheets [VBA]

In this post I am going to show how to create a new sheet for each airplane using vba. The […]

Calendar with scheduling [vba]

Here is my contribution to all excel calendars out there. My calendar is created in Excel 2007 and uses both […]

Split values equally into groups

Question: How do I divide values equally into groups (3 lists or less)? This post shows you two different approaches, […]

      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
    Don´t forget to add my RSS feed and subscribe to new blog articles by email.
  • Free Blog Emails

     
  • Search website

sponsored