Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - IF loop
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba courses london - IF loop
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
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
|