vba if function code example
Example 1: vba if else
If condition_1 Then
result_1
ElseIf condition_2 Then
result_2
...
ElseIf condition_n Then
result_n
Else
result_else
End If
Example 2: vba if and
If LWebsite = "TechOnTheNet.com" And LPages <= 10 Then
LBandwidth = "Low"
Else
LBandwidth = "High"
End If
Example 3: how to use if condition in time vba
If Time > TimeValue("6:30:00") And Time <= TimeValue("14:30:00") Then Range("F" & Target.Row) = "1st Shift"
If Time > TimeValue("14:30:01") And Time <= TimeValue("23:30:00") Then Range("F" & Target.Row) = "2nd Shift"
If Time > TimeValue("23:30:01") And Time <= TimeValue("6:30:00") Then Range("F" & Target.Row) = "Overtime"