Forum Discussion
Unacceptable pop-out error formatting
Hi, I'm looking for a way to make a value that doesn't fit acceptable criteria to have a message pop-up to say error or unacceptable, etc. Say a reagent is out of stability, when the date is put in, I want a comment to pop-up and say something like out of stability. Is that doable?
3 Replies
Here are some simple examples, with and without VBA.
Please see the examples in the attached file.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- Maybe you're looking for data validation? Check out the following:
https://support.microsoft.com/en-us/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249- Hi, I did manage to use the data validation to make a pop-up but unfortunately it only pops up when you type the date in. It doesn't work when copying and pasting the previous day's entry, which happens quite a bit. So say the reagent expired yesterday. So if the person copy and pasted from yesterday's entry it will still turn red since I set up conditional formatting but it won't have the error pop-up. Is there a way to make it pop-up if applicable when copying and pasting? Thanks for your help!
