Trouble with validation

[funkymonkUK]

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?

[mangesh_yadav]

probably one of them is being treated as text, while the other as a number...


Mangesh

[funkymonkUK]

how do i check?

[mangesh_yadav]

what is cj_val
for the cell, just check in another cell, if
=ISTEXT(A1) should return true for text and false for number

Mangesh

[funkymonkUK]

ok the activecell.offsets are numbers. cj_val is the name of the textbox. how do i do a check on the textbox?

[mangesh_yadav]

Try CJ_val.Value

Mangesh