Home

Data validation and spin button

%3CLINGO-SUB%20id%3D%22lingo-sub-1034157%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%20and%20spin%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034157%22%20slang%3D%22en-US%22%3EDo%20you%20also%20try%20to%20eat%20your%20cake%20and%20have%20it%20too%3F%20Seriously%2C%20without%20seeing%20the%20actual%20spreadsheet%20and%20cell%20you're%20describing%2C%20it%20sounds%20like%20you're%20just%20overloading%20that%20poor%20cell%20with%20incompatible%20expectations.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20could%20upload%20a%20sample%20so%20we%20could%20see%20it%2C%20we%20could%20make%20more%20specific%20recommendations.%20Absent%20that%2C%20just%20trying%20to%20make%20sense%20of%20what%20you've%20written%2C%20I'd%20think%20you%20would%20achieve%20your%20goal%20by%20splitting%20up%20the%20conditions%20that%20need%20to%20be%20met%2C%20and%2For%20the%20functions%20that%20need%20to%20be%20performed%2C%20into%20two%20or%20more%20cells.%20That%20way%20you%20could%20see%20more%20clearly%20what's%20going%20wrong%2C%20perhaps%20use%20a%20conditional%20format%20rule%20on%20one%20or%20more%20to%20highlight%20when%20boundaries%20have%20been%20exceeded.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20upload%20a%20sample%20if%20you%20still%20need%20help...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1034113%22%20slang%3D%22en-US%22%3EData%20validation%20and%20spin%20button%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1034113%22%20slang%3D%22en-US%22%3E%3CP%3EOk%2C%20so%20basically%20I%20applied%20a%20data%20validation%20over%20a%20cell%20so%20that%20it%20can't%20be%20more%20than%2016.%20When%20this%20happens%2C%20a%20message%20appears%20saying%20that%20you%20can't%20do%20that.%20The%20problem%20is%20that%20I%20also%20assign%20a%20spin%20button%20to%20the%20cell%2C%20but%20when%20I%20increase%20the%20number%20with%20the%20button%2C%20and%20the%20number%20of%20the%20cell%20exceeds%2016%2C%20nothing%20happens.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20fix%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1034113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Ok, so basically I applied a data validation over a cell so that it can't be more than 16. When this happens, a message appears saying that you can't do that. The problem is that I also assign a spin button to the cell, but when I increase the number with the button, and the number of the cell exceeds 16, nothing happens.

 

How can I fix that?

 

Thanks in advance!

 

 

 

 

1 Reply
Highlighted
Do you also try to eat your cake and have it too? Seriously, without seeing the actual spreadsheet and cell you're describing, it sounds like you're just overloading that poor cell with incompatible expectations.

If you could upload a sample so we could see it, we could make more specific recommendations. Absent that, just trying to make sense of what you've written, I'd think you would achieve your goal by splitting up the conditions that need to be met, and/or the functions that need to be performed, into two or more cells. That way you could see more clearly what's going wrong, perhaps use a conditional format rule on one or more to highlight when boundaries have been exceeded.

But upload a sample if you still need help...