Hi

I have a user form which has a First entry and which the user enters in data after which they press ok and the data is insertedinto the spreadsheet. however on the validation page which the user enters in the same data i have some validation code which searchs the list of data and then if a cell is not equal to what the user has entered it brings up an input box with the two different figures and askes them to choose.

All is working except that when it gets to the different data is keeps on poping up asking which is correct and both figures with the input box is showing is exactly the same. any ideas?

If ActiveCell.Offset(0, -11).Value <> CJ_val Then
answer = InputBox("Which answer is correct for CJ Hours? A: " & ActiveCell.Offset(0, -11).Value & " or B: " & CJ_val & ". Please type A or B and press OK.")
If answer = "B" Or answer = "b" Then
ActiveCell.Offset(0, -11).Value = CJ_val.Value
End If
End If
The above code the validation part. say the user first entered in 1 (As the user only has to enter in 1-10 and thats it, and the second time they enter it in as 1 it comes up asking if the right answer is 1 or 1?