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?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=380024