Hey, I am using Excel 2003, and i have a validation set on 'B10' which is:

Whole number, Greater than =C10

Because column B is a stock level column and when is falls below the 'restock level' (column C) then a validation message appears saying 'Reorder ....'. However I have now added spinners to change values in column B and now when it falls below it doesnt work. It still works if i enter it manually but adjusting it with the spinners doesnt work.

Is there anyway around this?

Thanks, lizi

Validation may not be the best way to flag a reorder point for the spinner, Lizi. Try this:

Suppuse the reorder message (validation error message) is in column D (though it doesn't matter).
Replace the validation message with a cell formula like:
=IF(B10<=C10, "Reorder ...", "")
The spinner normally handles your integer need anyway, so you can have the same message in the same place at the time you want.

Thank you thats great, exactly what i needed