Sub if_sample() Dim i As Integer For i = 1 To 300 If i = 1 Then Debug.Print "i值等于1" ElseIf i = 20 Then Debug.Print "i值等于20" ElseIf i = 40 Then Debug.Print "i值等于40" ElseIf i = 100 Then Debug.Print "i值等于100" ElseIf i = 300 Then Debug.Print "i值等于300" End If Next i End Sub
(2)select case;
Sub select_sample() Dim i As Integer For i = 1 To 300 Select Case i Case 1: Debug.Print "i值等于1" Case 20: Debug.Print "i值等于20" Case 40: Debug.Print "i值等于40" Case 100: Debug.Print "i值等于100" Case 300: Debug.Print "i值等于300" End Select Next i End Sub