Userform two way issue

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.

Any chance you could post your workbook?
Far easier to provide a solution if we don't have to recreate it.


BSB

What does "make this a two way thing?" mean to you? Be more specific.

Originally Posted by stnkynts

What does "make this a two way thing?" mean to you? Be more specific.

Sorry that is a bit vague I suppose. If I scroll to a date in the userform for example, and that date is already in the table, then I want the boxes in the userform to correspond to that date. I want to be able to change these if necessary, or still add new ones as it can do now.


Using my example from my initial post, my userform drop boxes should all have "Sian" in them.

I've had to delete one of the sheets to make the file fit, but it's not needed for the task I'm working on!

It's the schedule sheet where the table is.

Hello,

This is my try for this. Read my comments. I hope this will help you.

Thanks

KVS Version 4.xlsm

Originally Posted by gmr4evr1

Might have to change Userform1.Show in module2 to Userform2 or frmSchedule

Excellent catch. Thanks

This is the updated workbook.

KVS Version 4.xlsm

Thank you both! That's exactly what I was looking for.

The level of help on this forum is incredible.

I am glad I was able to help