I'm looking to code a button that does the following. There are two
values entered on sheet1, Textbox1 and TextBox2. When the button is
clicked on sheet1 the program should search sheet2 columnA for any
matches to the value entered in TextBox1. If a match is found then the
value from TextBox2 is inserted into columnB like so:


I.e. TextBox1 = XXXXX TextBox2 = 1234

ColumnA ColumnB
XXXXX 1234

Any help would be much appreciated.