Hey Team Excel!

I've created a userform in VB that can populate a table, but my question is how can I make this a two way thing?

This is what populates the table when I press okay.

Private Sub OkayButton_Click()

Dim emptyRow As Long

'Make Schedule Sheet active
Sheets("Schedule").Activate

'Determine emptyRow
emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1

'Transfer information
Cells(emptyRow, 1).Value = Format(DateBox.Value, "ddmmyy")
Cells(emptyRow, 2).Value = Format(DateBox.Value, "dd/mm/yy")
Cells(emptyRow, 3).Value = ONAMBox.Value
Cells(emptyRow, 4).Value = BRBox.Value
Cells(emptyRow, 5).Value = DABox.Value
Cells(emptyRow, 6).Value = NIBox.Value
Cells(emptyRow, 7).Value = ONPMBox.Value

End Sub
This is the userform.

userform example.png

So at the moment I can basically add multiple entries of the same date, rather than it being interactive.

Anyone got any thoughts?

Thanks in advance.