Go easy on me, this is the very first userform and vba project I have written on my own. How do I write the code so that when the add button is clicked it adds the values in the form to the next empty row. Right now it just owerwrites the values in row 2.
![]()
Private Sub cmdAdd_Click() Cells(2, 1).Value = frmauditdb.lstSupName.Value Cells(2, 2).Value = frmauditdb.txtPlantName.Value Cells(2, 3).Value = frmauditdb.txtLastAuditDate.Value Cells(2, 4).Value = frmauditdb.txtLastAuditScore.Value Cells(2, 5).Value = frmauditdb.lstAuditType.Value End Sub
Bookmarks