Many of the column references of this code are the same
ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 1).Value = ListBox1.Text
ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 1).Value = ListBox2.Text
ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 1).Value = TextBox3.Text
ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 2).Value = ListBox3.Text
ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 2).Value = ListBox4.Text
ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 2).Value = TextBox16.Text
ThisWorkbook.Worksheets("Master Sheet").Cells(lastrow + 1, 3).Value = TextBox4.Text
The cells are being written to and over-written so that the data from the TextBoxes are the last thing written in the cells.
Bookmarks