[RESOLVED] Excel form

[vonoventwin]

I have a small form in excel (textbox1, textbox2, cmdbutton1)

When a use hits submit I want the data in textbox1 and textbox2 to display on my Worksheet(1) spreadsheet; textbox1 value into Column A and textbox2 in Column B.

I already have 80 rows in this sheet so how do I make it add a new row everytime.

[thelocaluk]

This is the solution for you using vb code. Open the forms code box in vb mode (I guess you used excel vb to create the form), then apply this code

Private Sub cmdbutton1_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("sheet1")

  'moves to the next empty row
  iRow = ws.Cells(Rows.Count, 1) _
  .End(xlUp).Offset(1, 0).Row

  'enters data onto sheet1
  ws.Cells(iRow, 1).Value = Me.textbox1.Value
  ws.Cells(iRow, 2).Value = Me.textbox2.Value

  'resets form
  Me.textbox1.Value = ""
  Me.textbox2.Value = ""

End Sub

[vonoventwin]

Thanks sir! I will try right now.

[vonoventwin]

Worked perfect! THanks!

[vonoventwin]

Is there anyway I can find the syntax how to do this stuff without asking??

[thelocaluk]

sorry, I don't no of any website that provides complete reference for coding but if you find one be sure to let me know