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.
VBA
Excel VBA tutorials — macros, events, automation, and everything you can script.
ROWS: 116UPDATED: OCT 2024SECTION: 02 · PAGE 5/5
October 8, 2024
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.
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.
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?
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.
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.
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.
Knapsack Problem in Excel VBA
Below we will look at a program in Excel VBA that solves a small instance of a knapsack problem.
FormulaR1C1 Property in Excel VBA
This example illustrates the difference between A1 R1C1 and R[1]C[1] style in Excel VBA.
Select Case in Excel VBA
Instead of multiple If Then statements in Excel VBA you can use the Select Case structure. Let's explore this through two examples.
Text Box in Excel VBA
A text box is an empty field where a user can fill in a piece of text. To create a text box in Excel VBA execute the following steps.
From Active Cell to Last Entry in Excel VBA
This example illustrates the End property of the Range object in Excel VBA. We will use this property to select the range from the Active Cell to the last entry in a column.
Convert to Proper Case in Excel VBA
Below we will look at a program in Excel VBA that converts text to proper case. That is the first letter in each word in uppercase and all other letters in lowercase.
Error Handling in Excel VBA
Below we will look at two programs in Excel VBA. One program simply ignores errors. The other program continues execution at a specified line upon hitting an error.
Excel VBA Tutorial
VBA (Visual Basic for Applications) is the programming language of Excel. If you're an Excel VBA beginner these 16 chapters are a great way to start. Excel VBA is easy and fun! With Excel VBA you can automate tasks in Excel by writing so called macros.
Randomly Sort Data in Excel VBA
Below we will look at a program in Excel VBA that randomly sorts data (in this example randomly sorts names).
Areas Collection in Excel VBA
This page illustrates the Areas collection in Excel VBA. In the example below we have bordered the range B2:C3C5:E5. This range has two areas. The comma separates the two areas.
Exploring the Excel VBA Generator
Uncover the power of Excel VBA with our comprehensive guide to the Excel VBA Generator.