My UserForm is on sheet1 ("Dashboard") - but when the command button is clicked, I want the values to go the next empty row on the 3rd worksheet ("Data"), which is hidden.
The code I have works half way - it will transfer to the correct sheet, but it's reading the next empty row from the first sheet, the Dashboard, not from the Data worksheet.
Thanks!!![]()
Private Sub SaveClose_Click() Dim ws1 As Worksheet: Set ws1 = Sheets("Dashboard") Dim ws3 As Worksheet: Set ws3 = Sheets("Data") Dim emptyRow As Long emptyRow = WorksheetFunction.CountA(Range("$C:$C")) + 1 ws3.Cells(emptyRow, 3).Value = cboSupName.Value End Sub
-HeyInKy
Bookmarks