Saturday, September 3, 2016

Excel Vba :Copy The Listbox Items Into Closed Workbook

We have used address book template as sample in this study.

List of the listbox (or filtered items) can be copied into other closed workbook with a button.



Is pressed "copy button", sheets of the closed workbook are listed in the drop-down list. So that ,user can copy the contents of the listbox to the page it wants.