lightmaster
New Member
- Joined
- Feb 7, 2018
- Messages
- 13
I've got a Form Control Scrollbar that changes the number of hours in cell D23. Cell C26 preforms a calculation that results in a percentage based on the number of hours in D23. I have data validation enabled on D23 such that when C26 exceeds 100%, it throws an error. The issue is that when you adjust the scroll bar that changes the value of D23, it ignores the data validation and lets C26 exceed 100%. Is there any way to prevent this issue?