Nicola has attended:
Excel VBA Intro Intermediate course
Select case
How do you do a case select routine
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