Excel VBA Listbox Selection Types And Copying The Selected Data

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



Excel VBA listbox selection types :
Single Item Selecting
     VBA code to select single item :        ListBox2.MultiSelect = 0  


 Multiple Items Selecting
      VBA code to select multiple item :    ListBox2.MultiSelect = 1  
➤ Multiple Selection By Pressing  keys
      VBA code to select multiple item by pressing Ctrl and Shift keys :   ListBox2.MultiSelect = 2  

   

12 comments:

  1. Excellent work. Please tell me How to down load with vba code.

    ReplyDelete
  2. I copy pasted the "send to" code from the commandbutton 1 into my uderform code and replaced the listbox to my listbox (name) and replaced the sheet name where I want it to be sent at, however, it keeps giving me an out of range message

    ReplyDelete
  3. ls sheet name correct? Sheets("SelectedData")

    ReplyDelete
  4. CAN YOU PLEASE TELL HOW TO USE ?

    ReplyDelete
  5. Yes, I changed all the "SelectedData" to my sheet name, still getting the error though :/

    ReplyDelete
  6. Nevermind, I created a new sheet blank sheet and it worked!! thank you!

    ReplyDelete
  7. This is awesome! So helpful!

    ReplyDelete
  8. where's the code? :D

    ReplyDelete
    Replies
    1. Codes are in the workbook. Download it and press Alt+F11 keys on sheet. So, you can view the codes.

      Delete
  9. Hi The DOWNLOAD Link is not working. please place file in another site. so we can easily download.

    ReplyDelete
    Replies
    1. The above link is not allow to INDIA customers..
      Ur help is really appreciated....

      Delete