Home > Excel Tutorial > Copy And Paste Item Or Items Selected From A Listbox

Copy And Paste Item Or Items Selected From A Listbox

Copy /Transfer Selected Rows Of Multiselect And Multi Column Listbox To Range Of Cells On Sheet 

– Single Item Selecting

– Multiple Items Selecting

– Multiple Selection By Pressing Ctrl And Shift

Code of selections (single item,multiple items etc.) :

Private Sub OptionButton1_Click()
ListBox2.MultiSelect = 0
End Sub

Private Sub OptionButton2_Click()
ListBox2.MultiSelect = 1
End Sub

Private Sub OptionButton3_Click()
ListBox2.MultiSelect = 2
End Sub

In the page  searchable with the userform.

Items selected by the above methods are copied to other page (SeletctedData).

The first blank cell in  column A is selected while transferring .

Click Here More Info and To Download Template

  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: