Validation and Spinnerbuttons

  • Thread starter Thread starter Naan
  • Start date Start date
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 !! :)
 
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.
 
okay thanks I've already done conditional formatting. I'll see what else
i can do thanks though
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Frontpage increases text size 6
automatically create a spinner and link it when a button is pressed 1
calculating a total in one field from other fields on a form 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Choosing a new laptop. 7
how do i autosave my work? 4
Hey 10
How can I mark pupil's work in a powerpoint presentation 2

Back
Top