Validation and Spinnerbuttons

N

Naan

Hi I am doing GCSE ICT at my school and I am making a 'School Shop' for
my coursework. What I need is to do is use the Validation Warning
Message and the SpinnerButton to set that off. But they seem not to
work together. :confused:

Anyone who understood this please may you Reply as soon as possible
thanks soo much !! :)
 
D

Debra Dalgleish

Data validation is triggered when you type something in a cell, not when
the value is changed by a spinner.

You could use conditional formatting to change the cell colour, if the
cell value is not valid.
 
N

Naan

okay thanks I've already done conditional formatting. I'll see what else
i can do thanks though
 
Top