Unacceptable pop-out error formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2621107%22%20slang%3D%22en-US%22%3EUnacceptable%20pop-out%20error%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2621107%22%20slang%3D%22en-US%22%3EHi%2C%20I'm%20looking%20for%20a%20way%20to%20make%20a%20value%20that%20doesn't%20fit%20acceptable%20criteria%20to%20have%20a%20message%20pop-up%20to%20say%20error%20or%20unacceptable%2C%20etc.%20Say%20a%20reagent%20is%20out%20of%20stability%2C%20when%20the%20date%20is%20put%20in%2C%20I%20want%20a%20comment%20to%20pop-up%20and%20say%20something%20like%20out%20of%20stability.%20Is%20that%20doable%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2621107%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2621193%22%20slang%3D%22en-US%22%3ERe%3A%20Unacceptable%20pop-out%20error%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2621193%22%20slang%3D%22en-US%22%3EMaybe%20you're%20looking%20for%20data%20validation%3F%20Check%20out%20the%20following%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fapply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fapply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2621371%22%20slang%3D%22en-US%22%3ERe%3A%20Unacceptable%20pop-out%20error%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2621371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F917317%22%20target%3D%22_blank%22%3E%40Sharon_Dquest1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20are%20some%20simple%20examples%2C%20with%20and%20without%20VBA.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EPlease%20see%20the%20examples%20in%20the%20attached%20file.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
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

@Sharon_Dquest1 

 

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.

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!