BeforeDoubleClick Event in Excel VBA
Code added to the Worksheet BeforeDoubleClick Event will be executed by Excel VBA when you double click a cell on a worksheet.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 17/22
October 8, 2024
Save in Excel 97-2003 Format
If you save your Excel files in 97-2003 format (.xls instead of the new .xlsx format) users who do not have Excel 2007 or later installed on their computer can still open your Excel files.
Insert Row Shortcut in Excel
To quickly insert a row in Excel select a row and use the shortcut CTRL SHIFT +. To quickly insert multiple rows select multiple rows and use the same shortcut.
How to Add a Column in Excel
To add a column in Excel right-click the column letter and click Insert. When you insert a column or row cell references update automatically.
Sales Calculator in Excel VBA
Below we will look at a program in Excel VBA that calculates the total sales of each employee over a period of three years.
Box and Whisker Plot in Excel
This example teaches you how to create a box and whisker plot in Excel. A box and whisker plot shows the minimum value first quartile median third quartile and maximum value of a data set.
Possible Football Matches in Excel VBA
Below we will look at a program in Excel VBA that shows a print preview of all the possible football matches from a list of teams.
Solve a System of Linear Equations in Excel
This example shows you how to solve a system of linear equations in Excel. For example we have the following system of linear equations:
Tax Rates in Excel VBA
Below we will look at a program in Excel VBA that calculates the tax on an income. The following tax rates apply to individuals who are residents of Australia.
Data Validation in Excel
Use data validation in Excel to make sure that users enter certain values into a cell.
Sort Birthdays in Excel VBA
Below we will look at a program in Excel VBA that sorts birthdays by months first and days second (so we ignore years). We want the birthday with the lowest month number at the first position. If there are birthdays with equal month numbers we want the birthday with the lowest day number first. Are you ready?
Text to Columns in Excel
To separate the contents of one Excel cell into separate columns you can use the 'Convert Text to Columns Wizard'. For example when you want to separate a list of full names into last and first names.
Color Scales in Excel
Color Scales in Excel make it very easy to visualize values in a range of cells. The shade of the color represents the value in the cell.
Debugging in Excel VBA
This example teaches you how to debug code in Excel VBA. By pressing F8 you can single step through your code.
Workbook and Worksheet Object in Excel VBA
Learn more about the Workbook and Worksheet object in Excel VBA. In Excel VBA an object can contain another object and that object can contain another object etc. In other words Excel VBA programming involves working with an object hierarchy. This probably sounds quite confusing but we will make it clear.
Add a Macro to the Toolbar in Excel
If you use an Excel macro frequently you can add it to the Quick Access Toolbar. This way you can quickly access your macro. First we record an empty macro.
Maximum Flow Problem in Excel
Use the solver in Excel to find the maximum flow from node S to node T in a directed network. Points in a network are called nodes (S A B C D E and T). Lines in a network are called arcs (SA SB SC AC etc).
Remove Duplicates in Excel VBA
Below we will look at a program in Excel VBA that removes duplicates.
Offset Property in Excel VBA
The Offset property in Excel VBA takes the range which is a particular number of rows and columns away from a certain range.
Create a Template in Excel
Instead of creating an Excel workbook from scratch you can create a workbook based on a template. There are many free templates available waiting to be used.
Import Sheets using Excel VBA
Below we will look at a program in Excel VBA that imports sheets from other Excel files into one Excel file.
Conflicting Conditional Formatting Rules in Excel
Sometimes multiple conditional formatting rules in Excel conflict. A higher rule always wins. This example illustrates two different results.
Chart Axes in Excel
Most chart types have two axes: a horizontal axis (or x-axis) and a vertical axis (or y-axis). This example teaches you how to change the axis type add axis titles and how to change the scale of the vertical axis.
How to Wrap Text in Excel
Wrap text in Excel if you want to display long text on multiple lines in a single cell. Wrap text automatically or enter a manual line break.