Validation Of Copy / Paste Data By Macro

Template is created where the users copy/paste the data from other file. Data validation has been performed with the following steps:

1. Macro inserts the vlookup formula into column A, which isused for validating data that is entered by user from column B to E.
2. If the data is incorrect the N/A will be displayed in column A and invalid data will behighlighted in red color in column B.
3. This validation goes through the loop and after the loop is finished the pop message will be displayed and macro should stop so the user can correct the data.
4. After the user correct the data, the macro needs to run again to make sure there is no further errors. If there are no errors, thehighlighted cells should be cleared out of color and pop.

Here is the code that runs by command button:

Private Sub CommandButton1_Click()
Call FindNA
End Sub
Sub FindNA()
Dim ResultRange As Range
Dim ResultCell As Range
Dim iRow As Integer

[Code] ......