show / hide menu


This function can be used to find if the given number is between a start number and end number. It returns a boolean value true or false based on the validation.

Syntax : Between(Number InputValue, Number StartNumber, Number EndNumber )
Number InputValue is number which needs to be validated.
Number StartNumber and EndNumber is number range that needs to be validated.

Examples :

textbox1.Value = Between( 22, 20, 30) – returns true, as 22 is between 20 and 30
textbox1.Value = Between( 10, 20, 30) – returns false, as 10 is not between 20 and 30