On Aug 22, 2006, at 12:56 PM, Terry Ford wrote:
On Aug 22, 2006, at 10:24 AM, Norman Palardy wrote:
On Aug 22, 2006, at 11:00 AM, Terry Ford wrote:
The problem is that he is attempting to use expressions that
require a boolean 'and' operation. Only a single evaluation or
the implied 'Or' (the separating commas) is allowed in a Select
Case statement.
Not true
The code I posted works just fine and uses AND in several places.
Try it
Correct. I just learned something new.
However:
1. You are not using 'Case Is' ( or his mysterious concept of 'Case
Between') on an integer value.
No, because it was not necessary
2. You are not comparing an Integer with a Boolean evaluation.
Because that gets you a type mismatch
3. You fixed up his illogical range selection somewhat but it is
still off a bit. :)
Case Y < 100 // Was: Y < 100 // Row #1
startY = 0
endY = 100
Case Y >= 100 and Y < 200 // Was: Is > 100 And Is < 200 // Row #2
startY = 100
endY = 200
Isn't the actual endY value no greater than 99 or 199 in the above
two Cases?
It might be but nitpicking aside I was just trying to give Emile a
way to do what he was attempting to do that does work with a select
case instead of a huge If then else
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
