Macro
Excel ยป VBA ยป Macro ยป
Copy data from workbooks in folder and subfolders
I will in this article demonstrate a macro that automatically opens all workbooks in a folder and subfolders, one by [โฆ]
How to copy non contiguous cell ranges
If you try to copy multiple cell ranges on a worksheet that don't have the same number of rows or [โฆ]
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. [โฆ]
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 [โฆ]
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 [โฆ]
Add your personal Excel Macros to the ribbon
If you find yourself using the same macros over and over again, you can create a personal *.xlsb file that [โฆ]
Working with TEXT BOXES [Form Controls]
What's on this page Insert a text box Font and font size Add or edit text Position a text box [โฆ]
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. [โฆ]
Count unique distinct values by cell color
PRASHANT asks: i need to count unique number in a specific coloured cell for eg if there are coloured cells [โฆ]
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 [โฆ]
What's on this page Copy a file Copy and rename a file Rename a file List files in a folder [โฆ]
How to change a picture in a worksheet dynamically [VBA]
Rahul asks: I want to know how to create a vlookup sheet, and when we enter a name in a [โฆ]
This article demonstrates how to move a shape, a black arrow in this case, however, you can use whatever shape [โฆ]
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 two [โฆ]
Hide specific columns programmatically
This article describes a macro that hides specific columns automatically based on values in two given cells. I am also [โฆ]
Copy worksheets in active workbook to new workbooks
This article demonstrates several VBA macros, they will save you time if you have lots of worksheets. The first macro [โฆ]
Copy Excel Table filter criteria programmatically
I will in this article demonstrate a macro that copies criteria from one Excel Table and applies them to another [โฆ]
This workbook contains two worksheets, one worksheet shows a calendar and the other worksheet is used to store events. The [โฆ]
Extract cell references populated with values [VBA]
This article demonstrates a macro that returns cell references for cell ranges populated with values on a worksheet. Jinesh asks: [โฆ]
Sort values in a cell based on a delimiting character [VBA]
This article demonstrates a macro that allows you to sort delimited data in a cell or cell range from A [โฆ]
Create new worksheets programmatically based on values in a cell range [VBA]
This article demonstrates a macro that inserts new worksheets based on names in a cell range. The cell range may [โฆ]
How to create an interactive Excel chart [VBA]
This article describes how to create an interactive chart, the user may click on a button or multiple buttons and [โฆ]
Sort values in an Excel table programmatically [VBA]
This article demonstrates how to sort a specific column in an Excel defined Table based on event code. The event [โฆ]
Prepare data for Pivot Table โ How to split concatenated values?
This article demonstrates a macro that allows you to rearrange and distribute concatenated values across multiple rows in order to [โฆ]
Search two related tables [VBA]
This article demonstrates a macro that automatically applies a filter to an Excel defined Table based on the result from [โฆ]
Create comment if cell value is larger than column
It can sometimes be helpful having a large cell value in a comment. You can then easily hover over cell [โฆ]
Change chart series by clicking on data [VBA]
The image above shows a chart populated with data from an Excel defined Table. The worksheet contains event code that [โฆ]
Excel template: Getting Things Done [VBA]
In this article, I am going to demonstrate a simple workbook where you can create or delete projects and add [โฆ]
To be able to use a Pivot Table the source data you have must be arranged in way that a [โฆ]
Add values to worksheets based on a condition [VBA]
This tutorial shows you how to add a record to a particular worksheet based on a condition, the image above [โฆ]
Add values to a two-dimensional table based on conditions [VBA]
This article demonstrates how to place values automatically to a table based on two conditions using a short macro. Cell [โฆ]
Add or remove a value in a drop down list programmatically
This article demonstrates how to add or remove a value in a regular drop down list based on a list [โฆ]
Open Excel files in a folder [VBA]
This tutorial shows you how to list excel files in a specific folder and create adjacent checkboxes, using VBA. The [โฆ]
Toggle a macro on/off using a button
This article demonstrates how the user can run a macro by clicking on a button, the text on the button [โฆ]
This article demonstrates how to automatically enter data in cells if an adjacent cell is populated using VBA code. In [โฆ]
Apply drop-down lists dynamically
This article demonstrates how to automatically create drop-down lists if adjacent data grows, there are two methods explained here. The [โฆ]
How to log when a workbook is opened and closed [VBA]
This article demonstrates how to automatically create log entries when a workbook opens or closes using event code. Column A [โฆ]
Auto resize columns as you type
Excel does not resize columns as you type by default as the image above demonstrates. You can easily resize all [โฆ]
Copy a dynamic cell range [VBA]
In this blog post, I will demonstrate some VBA copying techniques that may be useful if you don't know the [โฆ]
List all open workbooks and corresponding sheets [VBA]
In this post, I am going to demonstrate how to automatically create a new sheet in the current workbook and [โฆ]
In this small tutorial, I am going to show you how to create basic data entry with a small amount [โฆ]
List Excel defined Tables in a workbook [VBA]
The following macro inserts a new sheet to your workbook and lists all Excel defined Tables and corresponding Table headers [โฆ]
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]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above [โฆ]
Filter an Excel defined Table based on selected cell [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 populate a combobox based on column headers from [โฆ]
Add values to a regular drop-down list programmatically [VBA]
In this tutorial I am going to show you how to add values to drop down list in cell C2. This [โฆ]
Filter an Excel defined Table programmatically [VBA]
In this tutorial, I am going to demonstrate how to filter an Excel define Table through a VBA macro. How it [โฆ]
Populate a list box with unique distinct values from a filtered Excel table [VBA]
Excel defined Tables, introduced in Excel 2007, sort, filter and organize data any way you like. You can also format [โฆ]
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 [โฆ]
How to add a custom-made item to the shortcut menu [VBA]
This post describes how to add a new custom-built item to the shortcut menu in Excel, when you right-click a cell [โฆ]
Select cell A1 on all sheets before you close a workbook [VBA]
This post demonstrates a macro that automatically selects cell A1 on each sheet right before you close a workbook. The [โฆ]
How to save custom functions and macros to an Add-In
Macros and custom functions are great, they can automate many tedious tasks. To have them available whenever you need them, [โฆ]
Use text qualifiers to make text to columns conversion easier [VBA]
This blog post describes how to insert qualifers to make "text to columns" conversion easier. Example I copied a table from [โฆ]
This article describes how to create a button and place it on an Excel worksheet then assign a macro to [โฆ]
This post demonstrates how to view saved invoices based on the invoice number using a userform. The userform appears when the [โฆ]
Populate listbox with unique distinct values [VBA]
This post demonstrates how to: Insert a button to your worksheet Assign a macro to the button Create a basic [โฆ]
In a previos post:Excel vba: Save invoice data we added/copied data between sheets. This post describes how to overwrite existing [โฆ]
This article demonstrates a macro that copies values between sheets. I am using the invoice template workbook. This macro copies [โฆ]
Question: I have multiple worksheets in a workbook. Each worksheets is project specific. Each worksheet contains almost identical format. The [โฆ]
Rearrange values based on category [VBA]
In this post I am going to rearrange values from a list into unique columns. Before: After: The code Download [โฆ]
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 [โฆ]
Create a unique distinct list using Advanced Filter in a macro [VBA]
Question: hi all, thanks for the great formula/array formula. it works great. lately, i noticed that the array formula will [โฆ]
Identify missing numbers in a column
The image above shows an array formula in cell D6 that extracts missing numbers i cell range B3:B7, the lower [โฆ]
English
Spanish
