#Excel #VBA Tutorial - How to use 'Select Case' with condition

Judge a cell value on the following criteria
BETWEEN -1 TO -0.8 "SUPER NEGATIVE"
BETWEEN -0.8 TO -0.5 " NEGATIVE"
BETWEEN -0.5 TO 0.5 "weak"
BETWEEN 0.5 TO 0.8 "POSITIVE"
BETWEEN 0.8 TO 1 "SUPER POSITIVE"