BigWes1960
03-14-2013, 04:43 AM
Hi all, thanks for being here.
I have a worksheet with a Listbox on a Userform. I have made the Listbox a method of selecting items from the worksheet. The Listbox is populated with items from Column A, with a checkbox in the Listbox (multiselect).
I need to allow the user to select an item (or items) in the Listbox, and then place those selections into a new sheet (or another area on the same sheet) for eventually printing the selections made.
I just can't figure out how to reference the selections made in the Listbox, identify them, and put them into the next row.:banghead: :banghead: :banghead:
For example, I have a list of 8000 comic books that a user can scroll through. He selects 20 of them from various rows on the comic book spreadsheet (in the Listbox). When he clicks "okay" (or whatever), I want to place that list of 20 comic books in column A starting at row 1 of a new sheet. Then I can print this new sheet/list and give it to a picker who gets the items from inventory.
Thanks in advance! :bow:
I have a worksheet with a Listbox on a Userform. I have made the Listbox a method of selecting items from the worksheet. The Listbox is populated with items from Column A, with a checkbox in the Listbox (multiselect).
I need to allow the user to select an item (or items) in the Listbox, and then place those selections into a new sheet (or another area on the same sheet) for eventually printing the selections made.
I just can't figure out how to reference the selections made in the Listbox, identify them, and put them into the next row.:banghead: :banghead: :banghead:
For example, I have a list of 8000 comic books that a user can scroll through. He selects 20 of them from various rows on the comic book spreadsheet (in the Listbox). When he clicks "okay" (or whatever), I want to place that list of 20 comic books in column A starting at row 1 of a new sheet. Then I can print this new sheet/list and give it to a picker who gets the items from inventory.
Thanks in advance! :bow: