VBA---逻辑语句

逻辑语句

If True Then                 …..	If True Then                 ….. ElseIf True Then                 …… Else                 …… EndIf	Select Case Time                 Case Is < 0.5 [0 to 0.49]                                 ……                 Case Is < 0.5                                 ……                 Case Else                                 …… End Select	With Worksheets(“Sheet1”).Range(A1).Font                 .name = “仿宋”                 .size = 12                 .Bold = True End With
Dim i As Integer For i = 2 to 9 [Step1]                 ……                 [Exit For]                 …… Next [i]	Dim i As Integer For Each sht in Worksheets                 …….                 [Exit For]                 ……. Next [sht]	Dim i As Integer i = 2 Do [While True] [Until False]                 ……          [Exit For]      终止方式四选一                 …… Loop [Until False]	Dim i As Integer i = 1 x: ……   ……   If i <=100 Then GoTo X   …… 多用于调试代码