Cell check

[Robert Couchman]

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

 

[Tom Ogilvy]

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