Trouble with validation
 

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

Trouble with validation
 

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


Mangesh


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

Trouble with validation
 

how do i check

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38002

Trouble with validation
 

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

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=38002

Trouble with validation
 

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

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38002

Trouble with validation
 

Try CJ_val.Value

Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=38002

Trouble with validation
 

just above the code i put in the below

Range("ak15").Value = "=istext(cj_val.value)"

it result was that it was a number as well.

any ideas? how i could achieve the same result with a different
method.?


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

Trouble with validation
 

No, I meant try:

If ActiveCell.Offset(0, -11).Value < CJ_val.Value Then


Mangesh


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

Trouble with validation
 

I tried that and still no luck

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38002

Trouble with validation
 

When both return 1,

IsNumeric(ActiveCell.Offset(0, -11).Value)
and
IsNumeric(CJ_val.Value)

should return true.

Mangesh


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

Trouble with validation
 

WHERE must i put this code

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38002

Trouble with validation
 

I figured the problem out what i needed to do as put cj_hours.value /
to make sure it was a number now it works.

Thanks for you assistanc

--
funkymonkU
-----------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813
View this thread: http://www.excelforum.com/showthread.php?threadid=38002