Hello,
I'm new here. I want to make a simple thing.
I have a table in sheet named "Stock" with owner's staff (equipment, date from, date to and owner's name)
I put combobox with owners names in "list" Sheet and also a listbox
Now when I choose one owner name from combobox I want listbox to populate all rows with selected owner's name.
I tried this macro but it only populates lisbox with first column and it takes a lot of time...
Please, maybe You could help me find better way to do this..Please Login or Register to view this content.
I don't want to do a userform because I want to have at least 3 listboxes form different sheets in "List" sheet.
Here is a xlsm file.
Bookmarks