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.
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
Thanks!!
-HeyInKy
Bookmarks