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!