These codes work perfectly.

Now, I want to know if it is possible to empty the content of column
into a worksheet that as the same name as what is shown in column A.

example

I have 7 worksheets
worksheet 1 ------- which has the userform in it.
worksheet 2 ------- which is named after cell 'A10' in worksheet 1
worksheet 3 ------- which is named after cell 'A11' in worksheet 1
worksheet 4 ------- which is named after cell 'A12' in worksheet 1
worksheet 5 ------- which is named after cell 'A13' in worksheet 1
worksheet 6 ------- which is named after cell 'A14' in worksheet 1
worksheet 7 ------- which is named after cell 'A15' in worksheet 1

the userform
gets information from 'a10' and inserts that information into th
adjacent cell 'b10' and so on.

I would also like to have the information inserted in to the same cell
on the worksheet that is named after cell 'a10' and so on.

What code do I need to to this?

current code

Code
-------------------

Private Sub commandbutton1_click()
'get text
TextBox1.Text = Range("A4").Value
TextBox2.Text = Range("A5").Value
TextBox3.Text = Range("A6").Value
TextBox4.Text = Range("A7").Value
TextBox5.Text = Range("A8").Value

End Sub

Private Sub CommandButton2_Click()
'dump input
Range("B4").Value = TextBox6.Text
Range("B5").Value = TextBox7.Text
Range("B6").Value = TextBox8.Text
Range("B7").Value = TextBox9.Text
Range("B8").Value = TextBox10.Text

End Sub

-------------------

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46809