VBAマクロを使用することで：

①、定数宣言

Const Test = "Test"

②、変数宣言

Dim Test As Integer

Dim Test As String

Dim Test As Variant

③、Sub関数宣言

Sub Test() End Sub

Sub Test(Test As Integer) End Sub

 

④、Forループ

For i = 0 to 10

   MsgBox(i)

Next

⑤、Do...While

Do While i < 10

  MsgBox(i)

Loop

Do

  MsgBox(i)

Loop While i < 10

⑥、Do...Until

Do Until i > 10

MsgBox(i)

Loop

Do

MsgBox(i)

Loop Until i > 10