clear text from textbox's

Because your text box is in a worksheet and not a form, you need to insert the sheet reference

Sub Button2_Click()
 Sheets("Sheet1").TextBox1.Value = ""

End Sub

Edit: got sidetracked and solus gave you the answer. Good.