Home
BetterSolutions.com
Online Documentation
Microsoft Office Excel
Microsoft Office Word
JavaScript Programming
VBA Programming
C# Programming
Microsoft Office Excel
Workbooks
Worksheets
Rows Columns
Cells Ranges
Data Validation
Data Analysis
Pivot Tables
Power Query
Search Excel ...
Functions
User Defined
Formulas
Dynamic Formulas
Reviewing
Track Changes
Named Ranges
Conditional Format
Microsoft Word
Tables
Charts
Dates Times
Formatting
Illustrations
Layout
Importing
XML
Microsoft PowerPoint
Ribbon
Options
Shortcut Keys
Protection
Add-ins
Macros
Templates
Quant Finance
Microsoft Outlook
Microsoft Office Excel
Worksheet Functions List
Ribbon Tabs Explained
Keyboard Shortcut Keys
Best Practices
Search Excel ...
VBA Programming
Visual Basic Editor
Add-ins
Macros
Syntax
Arrays
Collections
Error Handling
Debugging
Search VBA ...
Data Types
Variables
Strings
Numbers
Dates Times
Files Directories
Events
Best Practices
Questions
Functions
Subroutines
MsgBox
InputBox
Userforms
Controls
XML
Databases
C# Programming
Ribbon
Options
Shortcut Keys
Enumerations
Class Modules
References
Web Services
SQL
JS Programming
VBA Programming
Complete Functions List
Recording Macros
Syntax And Loops
Best Practices
Search VBA ...
Bespoke Development
Office Add-in Development
JavaScript Office Add-ins
VSTO and C# Integration
Macros and VBA Programming
High Value Consultancy
Get In Touch
Excel
>
Data Validation
Microsoft Excel
Data Validation
User FAQs
Circle Invalid Data
Restriction Types ...
Any Value
Whole Number
Decimal
List
Date
Time
Text Length
Custom
Messages ...
Ignore Blank
Examples ...
Drop-Down Lists ...
Prevent Duplicates ...
Finding
Copying
Removing
Updates
Code - TypeScript
Code - VBA
Updated: 01 April 2024
01 April 2024
Date
Restricts dates that are after 1st July 2000. Text is not accepted.
© 2024 Better Solutions Limited.
All Rights Reserved.
© 2024
Better Solutions Limited
Top
Prev
Next
