Update worksheet cell value and Listbox rowsource with double click in another Listbox

[johnnytominaga]

Hey guys!


I'm working on a project that includes an User Form that should incorporate the following functionalities:


a) User searches a database by typing a value in a textbox
b) Once clicking "Search", the results are display in a Listbox
c) If an item in the Listbox is double clicked, the UserForm will fill out the rest of the form, which includes all data related to that item in the database
d) It will also fill out a second listbox with all other items in the database that have the same value in a specific column (for example, "City")


I've managed to make items 'a', 'b' and 'c' work, but I'm stuck on 'd'. I'm sending the value to be advanced filtered from the first listbox to the worksheet, but it only loads when I close the User Form.


How can I get it to update the cell value in the worksheet once the user double clicks the item in the first Listbox? Also, how can I make sure the second Listbox's rowsource is also updated with that same interaction?

Hope it didn't get too confusing.
I'll be glad to clear it up if needed.


Thanks a lot.