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!
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):Hope this helpsPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks