Hi everyone,

i am currently looking for a piece of code that will allow
me to check the value in a cell, with the text in
textbox1, i then want it to update the cell IF the text in
textbox1 is different to the value of the cell.

if this is possible please can someone let me know how to
do it?

thank you,

Robert Couchman

where is textbox1? what kind of textbox

if Textbox1.Text < Range("A1").Value then
Range("A1").Value = Textbox1.Text
End if

However, why waste the time checking -

Range("A1").Value = Textbox1.Text

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
Hi everyone,

i am currently looking for a piece of code that will allow
me to check the value in a cell, with the text in
textbox1, i then want it to update the cell IF the text in
textbox1 is different to the value of the cell.

if this is possible please can someone let me know how to
do it?

thank you,

Robert Couchman