Userform with Multiple Pages in Excel VBA
Below we will look at a program in Excel VBA which creates a Userform that contains multiple pages. This userform also contains images.
VBA
Excel VBA tutorials — macros, events, automation, and everything you can script.
ROWS: 116UPDATED: OCT 2024SECTION: 02 · PAGE 3/5
October 10, 2024
Controls Collection in Excel VBA
When creating Userforms in Excel VBA you can use the Controls collection to easily loop through controls and set a property of each control to a specific value.
Vlookup in Excel VBA
Use the WorksheetFunction property in Excel VBA to access the VLOOKUP function. All you need is a single code line.
Tasks on Schedule in Excel VBA
Below we will look at a program in Excel VBA that sets the background color of tasks that are on schedule to green and sets the background color of tasks that are behind schedule to red.
Userform in Excel VBA
This chapter teaches you how to create an Excel VBA Userform. The Userform we are going to create looks as follows:
Union and Intersect Methods in Excel VBA
The Union method in Excel VBA returns a Range object that represents the union of two or more ranges. The Intersect method in Excel VBA returns a Range object that represents the intersection of two or more ranges.
Option Buttons in Excel VBA
If you have more than one option button only one of the option buttons can be selected. To create option buttons in Excel VBA execute the following steps.
Spin Button in Excel VBA
A spin button can be used to increment a number in a cell. To create a spin button in Excel VBA execute the following steps.
ByRef and ByVal in Excel VBA
You can pass arguments to a procedure (function or sub) by reference or by value. By default Excel VBA passes arguments by reference. As always we will use an easy example to make things more clear.
Sort Numbers in Excel VBA
Below we will look at a program in Excel VBA that sorts numbers.
Resize Property in Excel VBA
The Resize property in Excel VBA makes a range a specific number of rows and columns smaller or larger. The Resize property always takes the top left cell of a range as the starting point.
Dynamic Array in Excel VBA
If the size of your array increases and you don't want to fix the size of the array you can use the ReDim keyword. Excel VBA then changes the size of the array automatically.
Bills and Coins in Excel VBA
Below we will look at a program in Excel VBA that splits an amount of money into bills and coins.
For Loop in Excel VBA
Looping is one of the most powerful programming techniques. A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.
Dynamic Range in Excel VBA
Below we will look at a program in Excel VBA that colors the maximum value of a dynamic range.
Read Data from a Text File using Excel VBA
Below we will look at a program in Excel VBA that reads data from a text file. This file contains some geographical coordinates we want to import into Excel.
Type Mismatch Error in Excel VBA
The type mismatch error in Excel VBA occurs when you try to assign a value to a variable that isn't of the correct type.
Mod Operator in Excel VBA
The Mod operator in Excel VBA gives the remainder of a division. This page starts with some simple examples.
Events in Excel VBA
Events are actions performed by users which trigger Excel VBA to execute code.
Reverse Strings in Excel VBA
Below we will look at a program in Excel VBA that can reverse strings.
Loop through Defined Range in Excel VBA (For Each Cell in Range)
Below we will look at a program in Excel VBA that loops through a defined range. For example when we want to square the numbers in the range A1:A3.
Year Occurrences in Excel VBA
Below we will look at a program in Excel VBA that counts the number of year occurrences.
Progress Indicator in Excel VBA
Below we will look at a program in Excel VBA that creates a progress indicator. We've kept the progress indicator as simple as possible yet it looks professional. Are you ready?
Sum by Color in Excel VBA
Below we will look at a program in Excel VBA that sums numbers by color.