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?