Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Select case 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 - Select case loop
Resolved · Low Priority · Version Standard
Reply Thu 1 Feb 2007, 10:07
Edited on Thu 1 Feb 2007, 16:06Delegate Jennifer said...
Jennifer has attended:
Excel Advanced course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Select case loop
How do I create an Select case loop?
For upcoming training course dates see: Pricing & availability
RE: Select case loop
A Select Case loop is a better way of running multiple IF statements. The syntax is
Select Case <Variable>
<Run Code>
End Select
eg.
Select Case City
Case "London"
Delivery = 50
Case "Glasgow"
Delivery = 75
End Select
|