Help with IIF Condition

[Nigorr]

I want to get a number between 65 and 90 (ascii A-Z) I'm using the following but it aint working.

For z = 1 To 4
        Randomize
        Num = Round(Rnd * 218 + Rnd * 2, 0)
        blncontinue = True
        While blncontinue = True
          Cool = Num
          If Cool < 65 And Not Cool > 90 Then 'This is where I need help please
            Randomize
            Num = Round(Rnd * 218 + Rnd * 2, 0)
          Else
            blncontinue = False
          End If
        Wend
        randomString = randomString & Chr(Num)
      Next z

[Lord_Rat]

Why not:

Num = Round(Rnd * (90 - 65)) + 65

?

[Nigorr]

yes that would work fine, I didn't know how to do it that way, never thought of it. Thank you

[PeterPigmy]

Originally posted by Nigorr
[B] If Cool < 65 And Not Cool > 90 Then 'This is where I need help please

If you look at your logic there, it doesn't quite make sense. Read it out loud

If cool is LESS THAN 65 AND Cool is NOT GREATER THAN 90 then blah blah blah...

I would imagine what you originhally wanted was

if cool >65 and cool <=90 then blah blah blah

In other words if cool is GREATER than 65 AND cool is LESS THAN OR EQUAL TO 95 then blah blah blah

Hope this helps with your original logic.


Pigmy

[Nigorr]

Pigmy: That is what I originally had but it didn't work.... Kept getting other stuff

[Nigorr]

no no I see where I went wrong I had what I wanted done in the wrong spot ie, generate the new number should have been in the else bit while exit the loop should have been in the do this bit.

[PeterPigmy]

Originally posted by Nigorr
no no I see where I went wrong I had what I wanted done in the wrong spot ie, generate the new number should have been in the else bit while exit the loop should have been in the do this bit.

I find that when you have complicated if...then's that sometimes it's worth putting a "breakpont" in the code and when running it seeing where the IDE stops. That way you know the 'flow' that's running in your app.

Anyway, glad you got it sorted!!!!


Pigmy

[BuggyProgrammer]

IF and IIF (1 I vs 2 I's) are different. in case you didnt know, or maybe it ws a typo.

[Nigorr]

typo