Home > Excel Tutorial > Excel Vba :Copy The Listbox Into Closed Workbook

Excel Vba :Copy The Listbox Into Closed Workbook

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.

listbox transfer to closed workbook

Download Example Files

Advertisements
  1. Ivan Gray Cruda
    January 25, 2017 at 3:05 am

    Hello Sir

    Good Morning

    May I ask for help with your sample “Excel Vba :Copy The Listbox Into Closed Workbook”. Because I wanna use this as our records back up, but i find out, whenever i copy data to database sheets of the workbook it would reset data i pasted every time I copy a list of filtered data to the database.

    Please help me for this one, I’m just new to excel vba.

    Thank You so Much!
    Ivan

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: