VBA for Microsoft Excel

I need a simple input box from which to search values in columns A & B. In the example below the values in A & B represent starting and stopping station numbers with the plus symbol separating hundreds from tens... ie. 1+20 is understood as 120 linear ft. 100+00 is understood as 10,000 linear ft. A B 1| 0+00 1+20 2| 1+21 100+00 3| 2+00 99+00 4| 200+00. 208+00 In the input box I need to be able to enter any desired station number and search each non-empty row to discover if that value is equal to or in-between the values entered in column A & B. So if I enter 55+00 (5,500 linear ft) into the input box it should loop through each row and high light rows 2 & 3 because 5,500 is a value either equal to or between the values for columns A & B on those rows. There should be a reset feature as well because I will have to check multiple values daily.