Path and FullName Property in Excel VBA
The Path property in Excel VBA returns the complete saved path to the workbook (Excel file). The FullName property in Excel VBA returns the complete saved path including the name of the workbook.
VBA
Excel VBA tutorials — macros, events, automation, and everything you can script.
ROWS: 116UPDATED: OCT 2024SECTION: 02 · PAGE 2/5
October 11, 2024
Currency Converter in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that converts any amount from one currency into another.
Select Entire Rows and Columns in Excel VBA
This example teaches you how to select entire rows and columns in Excel VBA. Are you ready?
Instr Function in Excel VBA
Use Instr in Excel VBA to find the position of a substring in a string. The Instr function is quite versatile.
Separate Strings in Excel VBA
Below we will look at a program in Excel VBA that separates strings.
Prime Number Checker in Excel VBA
Below we will look at a program in Excel VBA that checks whether a number is a prime number or not.
Date Format in Excel VBA
Changing the date format in Excel VBA is easy. Use the NumberFormat property in Excel VBA to set the desired date format. Below are simple examples and tips to find the right date format.
Create a Footer Before Printing in Excel VBA
Below we will look at a program in Excel VBA that creates a footer before printing a workbook.
List Box in Excel VBA
A list box is a list from where a user can select an item. To create a list box in Excel VBA execute the following steps.
String Manipulation in Excel VBA
In this chapter you'll find the most important functions to manipulate strings in Excel VBA.
Excel Macro Comments (Easy VBA)
A macro comment is a piece of text in a macro which will not be executed by Excel VBA. It is only there to provide you information about the macro.
Sort a Range in Excel VBA
You can use the Sort method in Excel VBA to sort ranges in Excel. This article provides clear and practical examples to help you get started with sorting ranges using Excel VBA.
StatusBar Property in Excel VBA
The StatusBar property of the Application object in Excel VBA can be used to indicate the progress of a lengthy macro. This way you can let the user know that a macro is still running.
Loan Calculator in Excel VBA
This page teaches you how to create a simple loan calculator in Excel VBA. The worksheet contains the following ActiveX controls: two scrollbars and two option buttons.
Option Explicit in Excel VBA
We strongly recommend to use Option Explicit at the start of your Excel VBA code. Using Option Explicit forces you to declare all your variables.
Step Keyword in Excel VBA (Easy For Loop)
You can use the Step keyword in Excel VBA to specify a different increment for the counter variable of a loop.
Custom Average Function in Excel VBA
Below we will look at a program in Excel VBA which creates a user defined function that calculates the average of a randomly selected range excluding one or more values that are outliers and shouldn't be averaged.
CurrentRegion Property in Excel VBA
This example illustrates the CurrentRegion property in Excel VBA. The current region is a range bounded by any combination of blank rows and blank columns.
Cell Background Colors in Excel VBA
Changing background colors in Excel VBA is easy. Use the Interior property to return an Interior object. Then use the ColorIndex property of the Interior object to set the background color of a cell.
Multiple List Box Selections in Excel VBA
The MultiSelect property in Excel VBA allows a user to select multiple items in a list box.
Check Box in Excel VBA
A check box is a field which can be checked to store information. To create a check box in Excel VBA execute the following steps.
Combo Box in Excel VBA
A combo box is a drop-down list from where a user can select an item or fill in his/her own choice. To create a combo box in Excel VBA execute the following steps.
Month Names in Excel VBA
Below we will look at a program in Excel VBA which creates a User Defined Function that uses the Array function to return the names of the months.
Variables in Excel VBA
This chapter teaches you how to declare initialize and display a variable in Excel VBA. Letting Excel VBA know you are using a variable is called declaring a variable. Initializing simply means assigning a beginning (initial) value to a variable.