liam_conor
Board Regular
- Joined
- Oct 9, 2002
- Messages
- 180
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?
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?