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.

Photo

Excel: Spinners/validation Problem


  • Please log in to reply
2 replies to this topic

#1 lizi

lizi

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Local time:07:13 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)

 


m

#2 Geoffc

Geoffc

  • Members
  • 87 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Warragul, Australia
  • Local time:06:13 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

lizi
  • Topic Starter

  • Members
  • 33 posts
  • OFFLINE
  •  
  • Local time:07:13 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