98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - IF loop
vba courses london - IF loop
Resolved · Low Priority · Version Standard
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
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 tip:Stop Screen Flickering When Running CodeRunning VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place. |
