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
Dromerolovo95
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
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...
Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Excel Text Validation Help
TimothyE in Excel on
5 Replies
Synchronize file structure from inside of Teams
Deleted in Microsoft Teams on
1 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies