Data Validation 8 - Custom Error Messages in Excel

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to create custom error messages with this free Excel video tutorial. This shows you how to change the default data validation error messages to something that actually describes the error that was encountered. This is a particularly important feature to use when you need to let users know exactly what the error was that they caused so that they know how to correct the error.

This tutorial shows you how to change the error message image, title, and error message itself. This is a very important feature of data validation that should be implemented in most cases where there is data validation present in Excel.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• excel
• data validation
• error
• messages
• custom
• help
• problems
• worksheets
• pop up
• Technology
• Software
• tutorial

[ExcelisHell]

@simabah This method should work without a problem.

[simabah]

Thanks for sharing.I like your tutorials. Please keep up the good work.

Question: What if I already have a space in the middle of my data? for example a list of item numbers that look like this: 454 78 023. but I still don't want any spaces before or after the Item number? thx.