I have code to Copy and Paste columns of data based on a value in one cell. The user is to input the range of values for that cell, so I have the following lines


lower_limit = InputBox("lower OD limit")
upper_limit = InputBox("upper OD limit")

However, whatever value is in the cell will give True to < upper_limit and False to > lower_limit
MsgBox will show these limits as being assigned correctly, and they are declared as Single but do not seem to be being read as numbers/

If I set the values via

lower_limit = 0.15
upper_limit = 0.6

everything runs fine. Any clue what I have missed, or misused in the InputBox ?