Case issues in VBA

Case comparisons will be 1 of 3 conditions: True, False or something else. Change your Select Case to:

Please Login or Register  to view this content.

Hello ArenaNinja,

Here is your code with the Select Case statement equivalent. Select Case only "Or"s conditions, so you have to rewrite you conditional test from inclusive (>0 And <=5) to exclusive (<0 Or >5) for it to work.

Please Login or Register  to view this content.

Thanks for the replies guys.

Ross,

your idea makes sense, except that I really need to make these inclusive. I'm writing this for a friend (who can't show me his data) and he tells me he's got about 20 conditions he needs for letters A-G.

KH:

Looks like that worked! I think I can see in my head why now. Generally, select Cases are numbers, so you'll do case 1, case 2, case n. In this case, I was selecting to test a field value, and screwed up somewhere (still not sure where..).

Final code:

Please Login or Register  to view this content.

Sure, it's pretty badly written, but it'll do the job :D

Thanks guys!