vba courses london - Select case

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

Resolved · Low Priority · Version Standard

Select case

Nicola has attended:
Excel VBA course

by - delegate Nicola [1 post] (2007 Mar 8 Thu, 09:40) Reply

How do you do a case select routine

RE: select case

by - trainer Carlos gold contributer [413 posts] (2007 Mar 9 Fri, 16:09) Edited on 2007 Mar 9 Fri, 16:21 Reply

Nicola

The Select Case routine is usually prefered to large nested If routines.

A simple Select Case routine is as follows:

Select Case Weather

Case "Rain"
Instruction = "Wear a Raincoat"

Case "Sunshine"
Instriction = "Use Suncream"

End Select

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Good coding practice

It is important that you always comment the VBA code that you write. By doing this it will make the code much easier to read, as both yourself and other people will be able to see what the code is doing or meant to be doing. This is very important if there is more than one person who writes code in the company as you may have different styles of coding and may not really understand what the other person is trying to do. Also if you write some code and then do not touch it for a year or so you may actually forget what it is meant to be doing. so it is very important to include comments throughout your code and try and make sure that they are as useful as possible

View all VBA hints and tips