@ChipR
No Chip.
It is however very flexible and powerful ;)
Select Case is a very flexible and clear way of splitting the logic. It can handle multiple splits more clearly than multiple Ifs or even ElseIfs.
What can sometimes be a limitation is that the checks are not always done on the same items, even when the splitting of the logic all happens in one place. This is where the Select Case True comes in.
Think about it. The first of the Case statements to resolve to True will be selected when run. Elegant and supremely flexible.
Dan's code was actually quite valid (in its concept at least).