Thu 1 Feb 2007, 10:07
Edited on Thu 1 Feb 2007, 16:13Delegate Jane said...
Jane has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
IF loop
How do I create an IF loop?
Thu 1 Feb 2007, 16:18Trainer Carlos said...
RE: IF loop
An IF loop allows the user to check several conditions and run the approproate code for each condition. The syntax is
If <condition> Then
<Statement Block>
Else
<Statement Block>
End If
eg
If City = "London" Then
Delivery = 50
Else
Delivery = 75
End If
