MIN & MAX + Spin Button

I have an item: Apples. I want to be able to set the price on these using a spin button, but I don't want to go into the Format Control window in order to set the Min and Max values. I want these values to come from the spreadsheet. I need them to come from the spreadsheet as they constantly change and I have over 120 items.

I all ready tried a spin button, linked to the price cell, and restricting the info going into that cell with Data Validation, but that didn't work. Spin Button places any value, regardless of the Min/Max restrictions I placed for the cell.

Any suggestions?

I don't think I can set up a sample, so let me rephrase what I need...

I want to manually set up a number, with out it being over or under a set of given numbers. This is, if I have a range from 3 to 11, I want to be able to select any number withing this range, using a spin button.

Thanks! I had all ready tried to use the spin button, but I need for it to update automatically (MIN & MAX) from the range I mentioned above. I don't want to adjust the min/max values manually; I have 120 items and these constantly change.