Start Visual Basic code typing Practice. basic vb syntax, vb array typing practice, use of loop, each loops and if statment in vb typing practice.Click on the area below to start typing.
| S.No. | Paragraph : Practice repeatedly whatever you would like most for full fifteen minutes | Lessions | click to Practice |
|---|---|---|---|
| 1 | Sub Add10ToAllCellsInRange() Dim rng As Range For Each rng In Range("A1:A10") rng.Value = rng.Value + 10 Next End Sub Dim TestArray(10) As Integer, I As Variant For Each I In TestArray TestArray(I) = I Next I Sub RoundToZero() For Each rng in Range("A1:D10") If Abs(rng.Value) < 0.01 Then rng.Value = 0 Next End Sub | 1.4 | some for each loops in vb |