Archive for Macro
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. [โฆ]
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 [โฆ]
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 [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. [โฆ]
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 [โฆ]
Working with files using VBA in Excel
What's on this page Copy a file Copy and rename a file Rename a file List files in a folder [โฆ]
Rahul asks: i want to know that when we create a vlookup sheet, and in the name column we enter [โฆ]
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 [โฆ]
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. [โฆ]
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 [โฆ]
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 [โฆ]
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 [โฆ]
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 [โฆ]
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 [โฆ]
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 [โฆ]
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 [โฆ]
This article describes how to create a button and place it on an Excel worksheet. Then assign a macro to [โฆ]
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 [โฆ]
In a previos post:Excel vba: Save invoice data we added/copied data between sheets. This post describes how to overwrite existing [โฆ]
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 [โฆ]
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, [โฆ]
