Thu 8 Mar 2007, 09:40Delegate Nicola said...
Nicola has attended:
Excel VBA Intro Intermediate course
Select case
How do you do a case select routine
Fri 9 Mar 2007, 16:09
Edited on Fri 9 Mar 2007, 16:21Trainer Carlos said...
RE: select case
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
