TextBox1.Value = s
The above code tells Excel to put the data in 'TextBox1'. Since the code is in the UserForm code module it does not have to be preceded by 'UserForm1' (e.g. UserForm1.TextBox1.Value).