Quote Originally Posted by techgnome View Post
Bleh... now that means for each new combination added you have to do twice the work, first to add it as it's own logic, then again in the exception logic....

does no one use ElseIf any more? if I've satisfied the first condition, it should stop... no sense in doing any further checking...

-tg
tg, i just wanted to point out the solution to doogle's objection, but as you can see from my own post/code-sample i'd also still choose the select case.
and you're right: elseif would be the right method in sam's case