View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
dk[_2_] dk[_2_] is offline
external usenet poster
 
Posts: 21
Default how to input data into textboxes and make it appear on excelcells

On Apr 14, 8:09*am, Simon Lloyd
wrote:
Simply change this line
Code:
--------------------

* LastRow.Offset(13, 1).Value = TextBox2.Text

--------------------
*for this
Code:
--------------------

* LastRow.Offset(14, 0).Value = TextBox2.Text

--------------------
*the (13, 1) means 13 rows down 1 column across changing it to (14,0) is
14 rows down but none across just like your first textbox.


NON SENSE...

Just do what Kassie suggested.