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.

Please Login or Register  to view this content.

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.

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.

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.

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