Hello all, fairly novice with vba programming, especially using loops. I'm hoping someone can provide some help for a problem i'm having.
I have a column with a list of numbers ordered from smallest to largest. These numbers are cut-off values that have a meaning in my work. Users type a value into another part of the worksheet and I use that value to calculate a high and low bound. What i would then like to happen, is for excel to loop through the list of cut off numbers to see if the user's value is below a cut-off and the higher bound is above the cut-off or vice versa: if the user's value is above a cut-off and the lower bound is below a cutoff.

I'm not sure how to write this into VBA can anyone help? Thank you!