UserForm: Inserting Texbox input into selected cells.

[liam_conor]

I have created a userform that will insert textbox input from the user, by clicking a commandbutton, into the spreadsheet. Question: How do I take what the user inserts into the userform and insert it into the cells that the user has selected, for example:

Private Sub CommandButton1_Click()

Range("B11") = TextBox1.Value
Range("C11") = TextBox2.Value
Range("D11") = TextBox3.Value
Range("E11") = TextBox4.Value
Range("F11") = TextBox5.Value
Range("G11") = TextBox6.Value
Range("H11") = TextBox7.Value
Range("J11") = TextBox8.Value
Range("K11") = TextBox9.Value
Range("I11") = TextBox10.Value
Unload InsertBody

End Sub

This will insert into row 11 only. How do I insert the text value into a range they have preselected?

 

[liam_conor]

?

 

[Visions_Fugitive]

Try:

Selection.value = Textbox1.value