Question re: Data Validations and Custom Error Messages

Hello!

I’d like to know if I can have more than one validation in a cell. I’ve created a data validation list. The options are Yes, No, Pending. If “No” is selected, I’d like for an error message to pop up. Any ideas?

Thank you!

Not using data validation, but certainly can be done with VBA.

Try inserting this code into the Worksheet module (change the variable value of targetCell to match your spreadsheet, and the error message to whatever you like):

Please Login or Register  to view this content.

Hope this helps