You can use this

Sheets("Sheet1").Range("B2").Value = Me.TextBox1.Value


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dan" wrote in message ...
I am using a userform to input 17 different pieces of data into 17 textboxes/comboboxes. When the data has been input, and I
presses a button, I want it to place this data into cells on my spreadsheet. The first piece of data in cell "B2", the second into
"C2" and so on down the row. Each of the input boxes has a different name which I gave it to make it easier for me to keep track of,
like "username" instead of "combobox1", etc. Is there an automated way of having it input the data into the correct cells?