Multiple Loops in Excel VBA

In this article we are going to learn how to use multiple loops in VBA. We are going to use the For Next Loop.

To add a command button click on “Insert” and then select “Command Button” from ActiveX group.

insert command button

Create a command button.

create command button

Write click on the command button and Select “View Code“.

select view code

Write this line of code. After writing the code, close the window by clicking on the red X button on the top left of the screen.

Dim i As Integer, j As Integer
For i=1 To 1 to 6 
For j=1 To 2
Cells (i, j).Value=100
Next j
Next i 

vba code

Click on the command button to see this result.

click command button

That’s it!


You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial