Excel VBA Colon

Question

I have the following declaration in Excel VBA

Public Const cdbArea = 1: Public Const cdbDist = 2: Public Const cdbChange1 = 4: Public Const cdbChange2 = 5: Public Const cdbTR = 5:
Public Const crbArea = 1: Public Const crbDist = 2: Public Const crbTerr = 3: Public Const crbChange1 = 4: Public Const crbTR = 5:
Public Const cdbWeek1 = 4

On first glance, the Colons look like separators, but I have never used this syntax before.

What are the Colons for?

Answer 1

To seperate statements.

Possible duplicate?

Answer 2

You can put the statements on separate lines, if you like:

Public Const cdbArea = 1
Public Const cdbDist = 2
Public Const cdbChange1 = 4

Or, you can separate them with colons as in your example above.