Userform database

[Gordonhk]

Hi everyone,

I am trying to build a new database in Excel for students to submit any issues they have. Can someone provide me with the VBA code where I can save all the information in a spreadsheet like a database. I just managed to save information in 1 row. How can I build a database which data can be saved from the 1 row to infinity.

This is the code I am using (interface is built in userform)


Private Sub CommandButton1_Click()
Sheet2.Activate
eRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Cells(eRow, 3) = Creator.Text
Cells(eRow, 4) = ComboBox1.Value
Cells(eRow, 7) = Region.Text
Cells(eRow, 9) = TextBox4.Text
Cells(eRow, 2) = TextBox9.Text
Cells(eRow, 6) = ComboBox2.Value
Cells(eRow, 8) = ComboBox3.Value
Cells(eRow, 10) = TextBox5.Text
Cells(eRow, 5) = TextBox6.Text
Cells(eRow, 11) = TextBox7.Text
Cells(eRow, 12) = TextBox8.Text

Thanks for your help

Gordon

[Solus Rankin]

That will save the information in the last empty row every time you click the button. What else would you like it to do?

One thing I noticed... you're finding the last row on sheet1 and then placing values in sheet2?