Cell check

  • Thread starter Thread starter Robert Couchman
  • Start date Start date
R

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
 
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
 
Back
Top