A syntactically complete unit that expresses one kind of action, declaration, or definition.
A statement generally occupies a single line, although you can use a colon (
:) to include more than one statement on a line. I do not recommend using a colon to put two statements on the same line in VBA.
You can also use a line-continuation character (
_) to continue a single logical line onto a second physical line.
For i = 1 To 10: ProcessFoo (i): Next
Dim x As Long: x = 1
line-continuation character example:
Private Sub Chart_SeriesChange(ByVal SeriesIndex As Long, _ ByVal PointIndex As Long) Set p = ActiveChart.SeriesCollection(SeriesIndex). _ Points(PointIndex) p.Border.ColorIndex = 3 End Sub