VBA Excel

Illustration that shows the For Each loop in VBA by way of a few graphics

VBA For Each Loop

The For..Each is a loop type in VBA. This loop is used to execute one or more statements for arrays or collections

Combining elements in VBA: Visual representation of concatenating strings, integers, and variables.

How to Concatenate Strings, Integers, Variables, Cells in VBA

In VBA, you may concatenate values, strings, variables, and Excel data by using the ‘&’ operator.

VBA If Statement with And Operator [4 Examples]

VBA If..And statement is used when you have to test multiple conditions to execute one or more statements.

8 Examples to Add Sheet in Excel by VBA

A new sheet can be added by Sheets object’s Add method. For example,

Sheets.Add

This code will add a sheet before the active sheet in your Workbook.

Excel/VBA Active sheet: Learn to Access, Rename, Activate with 4 Examples

In this tutorial, how to make a non-active sheet in Excel an active sheet by using VBA code.

5 Examples to Insert and Use Excel/VBA Text box

In this tutorial, you will see how to insert text box ActiveX control in Excel sheet. We will also show how to write VBA code to fill text in the text box control.

Delete 1, 2 or More Excel Sheets in VBA by Name, Number etc.

In this tutorial, we will show you how to delete one or more sheets by using VBA Sheet.Delete method.

How to Add VBA/Excel Command Button

The VBA/Excel command button is an ActiveX control. Command button is used to perform certain task as a user clicks on it.

VBA While and Do While loops with conceptual graphics

While and Do Loops in VBA

The VBA while loop is used to execute the given statements as long as the condition is True. If the condition is false on first check, the execution moves out of the while loop.

VBA For Loop Tutorial art illustrations with VB and Excel Logos

For loop in Excel VBA

The VBA for loop is used to execute the group of statements for the given number of times. The for loop should be used if you know how many times a loop will run in advance.