Question : vba if else
Answered by : poised-pelican-ldiflu1yh6q8
If condition_1 Then result_1
ElseIf condition_2 Then result_2
...
ElseIf condition_n Then result_n
Else result_else
End IfSource : https://www.techonthenet.com/excel/formulas/if_then.php | Last Update : Thu, 02 Jul 20
Question : vba if and
Answered by : innocent-ibis-xtvpp7mhfhwx
If LWebsite = "TechOnTheNet.com" And LPages <= 10 Then LBandwidth = "Low"
Else LBandwidth = "High"
End IfSource : https://www.techonthenet.com/excel/formulas/and_vba.php | Last Update : Sat, 26 Dec 20
Question : how to use if condition in time vba
Answered by : rajesh-thevar
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("B:B")) Is Nothing Then
Range("D" & Target.Row) = Date
Range("E" & Target.Row) = Format(Now, "hh:mm:ss")
End If
End SubSource : https://stackoverflow.com/questions/38401309/set-an-if-statement-on-a-cell-depending-on-the-time-frame | Last Update : Thu, 24 Sep 20