It would be something like

With Worksheets("Sheet1")
.Range("A1").Value = Textbox1.Text
.Range("A2").Value = Textbox2.Text
'etc.
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cakonopka " wrote in message
...
Hi there

I am so stuck on this, i need to when i press a button, for all the
text i have entered into my text boxes which is customer data to be
entered into the table of data nd a new row added for the next data to
be entered into, any ideas anyone, My file is attached???

cheers

from ck


---
Message posted from http://www.ExcelForum.com/