Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Excel: Spinners/validation Problem

  • Please log in to reply
2 replies to this topic

#1 lizi


  • Members
  • 33 posts
  • Local time:05:54 PM

Posted 10 February 2008 - 05:51 AM

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

Edited by lizi, 10 February 2008 - 05:52 AM.

BC AdBot (Login to Remove)


#2 Geoffc


  • Members
  • 89 posts
  • Gender:Male
  • Location:Warragul, Australia
  • Local time:04:54 AM

Posted 12 February 2008 - 01:36 AM

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.

#3 lizi

  • Topic Starter

  • Members
  • 33 posts
  • Local time:05:54 PM

Posted 16 February 2008 - 06:57 AM

Thank you thats great, exactly what i needed

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users