Home > Excel Tutorial > Create A New Workbook From Selected Pages

Create A New Workbook From Selected Pages

Create A New Book From Selected Pages On Userform – Listbox Drag-Drop Event

          We put 3 list boxes on the userform and we added pages’ name of a book in the first listbox .

When clicked the page names in the listbox , content of the pages are displayed in another listbox.

To create a new book from selected pages, ago we drag page names from listbox to other listbox and we drop . Later when we press the button , a new book is formed.

listbox drap drop

 

We created a popup menu that working on the listbox

listbox popup menu

 

Example Can Be Downloaded Here

  1. No comments yet.
  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: