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