One Instruction Per Line

The accepted practice when writing VBA code is to put one instruction on each line.
This make the code much easier to follow and understand.

Sub DoSomething() 
   Dim iNumber1 As Integer 
   Dim iNumber2 As Integer 
   iNumber1 = 5 
   iNumber2 = 10 
   Call MsgBox(iNumber1 + iNumber2) 
End Sub 

It is possible to have multiple instructions on a single line by using a colon ":" to separate them.

Sub DoSomething() 
   Dim iNumber1 As Integer: Dim iNumber2 As Integer 
   iNumber1 = 5: iNumber2 = 10 
   Call MsgBox(iNumber1 + iNumber2) 
End Sub 

Or Even:

Sub DoSomething(): Dim iNumber1 As Integer: Dim iNumber2 As Integer: iNumber1 = 5: iNumber2 = 10: Call MsgBox(iNumber1 + iNumber2): End Sub