Hi There,
Could someone take a look at my code and tell me how to fix it please?
It's a simple code that was given to me by one of the forum members and after trying to implement it into my workbook I have come across an issue and have not been able to resolve it since.
Basically I have an input form which users uses to answer all questions and once they're ready to submit their answers they click on save button which then copies the range into the sheet called "Tracker" all of this works smoothly.
What doesn't work is the following:
On input form there are 3 columns called "Warning" "Minor" and "Major", upon selecting one of the cells in those 3 columns the code checks if there are any historical records in the tracker and if match is found it then displays the message to inform user that basically this issues was flagged up in the past and that they should upgrade to next stage.
Currently code fires up every time any of those cells is activated and even when mach is not found in the tracked..
Also the message is missing the piece of info whether a Warning, Minor or Major was found.
Capture.JPG
Capture1.JPG
Capture2.JPG
Hopefully I've explained this correctly.
Would appreciate your help.
Thank You
Dan
Bookmarks