I have a checkbox in my spreadsheet that is checked if my product is being put on a skid. When the checkbox is selected it controls a formula that determines how much time is added to the job based on whether or not it is skidded. However, if the length of my part is greater than 144" I would like to have the checkbox forced to be unchecked as we do not make skids larger than 144". When the part is 144" or shorter it should be optional to skid or not. Is there an easy way to do this?
Can you upload an example of how your checkbox and your formula interact (Go Advanced>Manage Attachments)?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Book1.xlsx
The attached file is an example of what I am trying to do. When I enter a length greater than 144" I want the cell that is linked to the checkbox to read false and the checkbox to uncheck. If the value is changed to 144 or less it should give me the ability to check or uncheck the box.
You'll need VBA. Right click on the tab and "View Code"
Something like this (adjust the cell where you will have your lengths)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks