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 - Select case loop
vba courses london - Select case loop
Resolved · Low Priority · Version Standard
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
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:Add A New Sheet at the end of the WorkbookTo add a new sheet at the end of the workbook you need to count the sheets in the workbook using: |
