Hi all,
I am trying to get two pop up message boxes for different criteria on different columns.
If the amount in column L is less than column H (in the corresponding cells) then a popup saying amount received is less than ordered; and in column G I am looking for a message to say if a number has been used before based on that cells contents.
Can anyone please advise on how to achieve this?
Thanks in advance for any help.
How and when do you want the pop ups triggered to appear? Do you want to manually run a macro whenever you want to check the data on columns G, L and H? Please describe in detail.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
This will work on cell change
and you can use conditional formatting to avoid duplicate entries in the other column
Please Login or Register to view this content.
https://www.excel-easy.com/examples/...e-entries.html
Last edited by nigelog; 09-20-2019 at 12:03 PM.
Thanks!
That's worked a treat thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks