Between Function

[Ascentient]

I am looking for a function in VBA that will check to see if the results of a calculation is between a range. I cannot seem to locate anything in the help file or from searches on the forumn.

Any suggestions other than the x > y and x < z approach?

 

[PHV]

What is wrong with the x > y and x < z approach?

 

[Ascentient]

Nothing. I just recall from another language that there was a function to do this, and I could not find one in VBA.

 

[PHV]

In fact, the right way in VBA is:
x >= y and x <= z

You may write your own function to emulate the Between [!]operator[/!] ...

 

[SkipVought]

"other language" YES.

In Structured Query Language there is a Between OPERATOR, but not in VB.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[ghalewood]

Here you go, see help on CASE, very versatile.

Dim IntValue as Integer
IntValue = 5 + 6

Select Case IntValue
Case 1 To 10
'blah
Case 11 To 12
'blah
Case Else
'blah
End Select