Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help Forums Windows Startup Programs Database Spyware and Malware Removal Guides Computer Tutorials Uninstall Database File Database Computer Glossary Computer Resources
 

Welcome Guest ( Log In | Click here to Register a free account now! )



Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, 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.

 
Reply to this topicStart new topic
> Excel: Spinners/validation Problem, Validation wont work with spinners.
lizi
post Feb 10 2008, 05:51 AM
Post #1


Member
**

Group: Members
Posts: 24
Joined: 31-March 07
Member No.: 121,168
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

This post has been edited by lizi: Feb 10 2008, 05:52 AM
Go to the top of the page
 
+Quote Post
Geoffc
post Feb 12 2008, 01:36 AM
Post #2


New Member
*

Group: Members
Posts: 14
Joined: 22-June 07
Member No.: 138,456
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.
Go to the top of the page
 
+Quote Post
lizi
post Feb 16 2008, 06:57 AM
Post #3


Member
**

Group: Members
Posts: 24
Joined: 31-March 07
Member No.: 121,168
Thank you thats great, exactly what i needed
Go to the top of the page
 
+Quote Post
« Next Oldest · Business Applications · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Lo-Fi Version Time is now: 9th January 2009 - 07:17 AM


Advertise   |   About Us   |   Terms of Use   |   Privacy Policy   |   Contact Us   |   Site Map   |   Chat   |   Tutorials   |   Uninstall List
Discussion Forums   |   The Computer Glossary   |   Resources   |   RSS Feeds   |   Startups   |   The File Database   |   Malware Removal Guides

© 2003-2008 All Rights Reserved Bleeping Computer LLC.

Powered By IP.Board © 2009  IPS, Inc.