Sunday, December 20, 2015

Listbox Selection Methods And Copying Of Selected Data

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

          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 .The border is drawn under of transfered data.



10 comments:

  1. Very nice! Danke

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

    ReplyDelete
  3. 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
  4. ls sheet name correct? Sheets("SelectedData")

    ReplyDelete
  5. CAN YOU PLEASE TELL HOW TO USE ?

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

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

    ReplyDelete
  8. This is awesome! So helpful!

    ReplyDelete
  9. 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