If your code is along the lines of
Range("A1").Value = Me.TextBox1.Value
then the value will be written to A1 of the active sheet (the one with the button) unless your code selects another sheet.
Surface Pro (2017) vs Surface Pro 4
20 groundbreaking 3D animation techniques
How to mine Bitcoin on Mac