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?
Thu 1 Feb 2007, 16:12Trainer Carlos said...
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
