Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save from form input
This must be really easy, but just don't know how to do it. I have a form
with 3 text input fields. I want to save inputs to "table1" first empty row to column A, B and C. -- -Sam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save from form input
Hello Sam
With Worksheets("Sheet1") ..Range("A65536").End(xlUp)(2).Value = TextBox1 ..Range("B65536").End(xlUp)(2).Value = TextBox2 ..Range("C65536").End(xlUp)(2).Value = TextBox3 End With HTH Cordially Pascal "Sam" a écrit dans le message de news: ... This must be really easy, but just don't know how to do it. I have a form with 3 text input fields. I want to save inputs to "table1" first empty row to column A, B and C. -- -Sam |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save from form input
With Worksheets("Sheet1") cLastRow =.Cells(Rows.Count).End(xlUp).Row If cLastRow = 1 And .Range("A1")="" Then Else cLastRow = cLastRow + 1 End If .Cells(cLastRow,"A").Value = Textbox1.Text .Cells(cLastRow,"B").Value = Textbox2.Text .Cells(cLastRow,"C").Value = Textbox3.Text End With -- HTH RP (remove nothere from the email address if mailing direct) "Sam" wrote in message ... This must be really easy, but just don't know how to do it. I have a form with 3 text input fields. I want to save inputs to "table1" first empty row to column A, B and C. -- -Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
How can I have an input form to add a random no. to each input entry? | Excel Discussion (Misc queries) | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
Input box/form | Excel Programming | |||
how to save the input of the controls in a form | Excel Programming |