Populate ComboBox from Database based on ListBox selection

[kukreja.v]

Hi Everyone,

I've been trying to populate a combobox from a database in a userform based on relevant listbox selection and display the entries in another database on a separate sheet.

Both ComboBox and ListBox entries will be from Database1 and the remaining entries in UserForm1 will be displayed in Database2

For Example, If i select "A" from Column A in ListBox, then everything in Column B associated with "A" in Database1 should appear in the ComboBox. Following my selection in ComboBox, i input the remaining entries in UserForm1 which would then be displayed in Database2.

Hope to get some positive responses and thanks in advance!

[Kyle123]

Welcome to the forum

Are you actually using a Database or just using Excel? It's not at all clear from your question.

It would also be immeasurably useful to upload a workbook that we can play with

[kukreja.v]

Hi Kyle123,

Thank you for coming forward to help out! Apologies for the confusion in my question.

I'm attaching a rough version of the workbook i'm trying to create. It has two spreadsheets, "Agreement DB" and "Amendment DB". There are also two UserForms, "UserForm1" to input details in Agreement DB and "UserForm2" to input details in Amendment DB.

In UserForm2, i want to populate whats under Column C in Agreement DB in the AgmtInput ListBox depending on what Primary Party you select in the P1Input ComboBox. The P1Input CombBox will be limited to those 11 items only.

All data entered into UserForm2 then goes straight into the Amendment DB.

Hope this is helpful!