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
Private Sub OptionButton2_Click()
ListBox2.MultiSelect = 1
Private Sub OptionButton3_Click()
ListBox2.MultiSelect = 2
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 .