💻 Software
Where is data validation text stored in Excel?
Fresh5 days ago
Mar 15, 20262234 viewsConfidence Score0%
0%
Problem
I have an Excel 2003 sheet with lots of different data validation rules. Is there anyway that they can be viewed other than through the regular data validation dialog? It would be helpful to export a list with validation error alerts, and rules, and check that list rather than through the dialog. A…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Where is data validation text stored in Excel?
Low Risk
There is an Excel VBA Validation object, associated with the range. See code: These properties are readable so you could pull out the the .InputTitle or .InputMessage or the min and max values allowed for that cell's validation programatically, to s…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix