vba courses london - Select case loop

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Select case loop

Jennifer has attended:
Excel Advanced course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course
Excel VBA course
Excel VBA course

by - delegate Jennifer [10 posts] (2007 Feb 1 Thu, 10:07) Edited on 2007 Feb 1 Thu, 16:06 Reply

How do I create an Select case loop?

RE: Select case loop

by - trainer Carlos gold contributer [479 posts] (2007 Feb 1 Thu, 16:12) Reply

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

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· How To Find A Good VB For Access Trainer
· Visual Basic Returns To The Macintosh
· Introduction to Visual Basic for Applications

Vba tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips