|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#2
July 13th, 2003, 06:40 PM
|
|||
|
|||
|
Not sure if there is a native function, but you could write your own along the lines of
Code:
function IsBetween(number,lower,upper)
If (CInt(number) <= CInt(upper)) AND (CInt(number) >= CInt(lower)) Then
return True
else
return False
end if
End sub
I haven't tested this, but you get the idea.
__________________
How can I soar like an eagle when I'm flying with turkey's?
|
|
#4
July 15th, 2003, 12:06 PM
|
|||
|
|||
|
why does it need to be a native function?
|
|
#5
July 15th, 2003, 06:09 PM
|
|||
|
|||
|
There isn't a native function in VBA, thus my previous answer is what you would need.
If you need to make it a "global" function, simply declare it as public. 
|
|
#6
July 16th, 2003, 01:04 AM
|
|||
|
|||
|
it doesn't matter so much (unatratnag,mohecan) - you're right. it's just me - prefering to do as less cpu as can. if there was (i understand there is not) a native, it would have been written in C lang, and therefore materialization whould have been optimal. tnx guys !
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > range/between |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
