Copying Text from TextBox into cells in table and then addign a new row

  • Thread starter Thread starter cakonopka
  • Start date Start date
C

cakonopka

Hi there

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

cheers

from c
 
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)
 
Back
Top