Vba :

[mahmed1]

Hi

What does it mean when there is a semi colon after a text

E.g
Do nothing:
Range[a1]:

thanks

 

[tigeravatar]

mahmed1,

This is a semicolon ;
The two-dots is a colon :

A colon in VBA tells the compiler to treat anything after the colon as a new line of code.

For example:

For i = 1 To 10
    MsgBox i
Next i

could instead be written as:

For i = 1 To 10: MsgBox i: Next i

This is not to be confused with colon equals :=
That indicates the assignment of a value or expression to a method's argument.
Using the above example, the msgbox Prompt argument is the variable i. I omitted the argument because its not necessary to explicitly state it. For the purposes of showing the difference between := and : though, the above example could be written as:

For i = 1 To 10: MsgBox Prompt:=i: Next i

 

[mahmed1]

mahmed1,

This is a semicolon ;
The two-dots is a colon :

A colon in VBA tells the compiler to treat anything after the colon as a new line of code.

For example:

For i = 1 To 10
    MsgBox i
Next i

could instead be written as:

For i = 1 To 10: MsgBox i: Next i

This is not to be confused with colon equals :=
That indicates the assignment of a value or expression to a method's argument.
Using the above example, the msgbox Prompt argument is the variable i. I omitted the argument because its not necessary to explicitly state it. For the purposes of showing the difference between := and : though, the above example could be written as:

For i = 1 To 10: MsgBox Prompt:=i: Next i

Thank you

 

[Leith Ross]

Hello mahmed1,

What you have shown is a colon ) not a semi-colon (.

A colon is used in VBA to tell the interpreter it has reached the end of a statement on that line. Multiple statements can appear on a single line when separated by colons.

N = 2: X = N ^ 2: MsgBox "N Squared = " & X

If a statement starts in column 1 of the VB editor and is followed by a colon with no other statements on that line, it is considered to a be a line label. You can transfer control to a line label with a Goto or GoSub statement.

If N <= 0 Then 
   GoTo EndMarco
End If

...

EndMacro:
    Application.Calculation = xlCalculationAutomatic
    Application.EnableEvents = True
    Application.DisplayAlerts = True

End Sub

 

[mahmed1]

Thank you