Listbox (MultiSelect)

**CobraLAD** · 03-12-2008, 11:55 PM

I have about 200 names in column A which I list in a listbox on a userfrom, which is set to multiselect

I want to be able to select certain names, and copy them to column G. I can do it with single select.

**jindon** · 03-13-2008, 12:06 AM

Please Login or Register  to view this content.

**davesexcel** · 03-13-2008, 12:33 AM

Here's a code that will place all the selected items from the listbox and place them in the first empty cell in column G

Please Login or Register  to view this content.

**CobraLAD** · 03-13-2008, 11:51 PM

Hi

Thanks Dave, I first saw nothing in column G, but then I noticed, sheet2

thanks it works

**jindon** · 03-13-2008, 11:58 PM

Should be working if you change the sheet name to appropreate.

Listbox (MultiSelect)

LinkBack

Thread Tools

Rate This Thread

Display

Listbox (MultiSelect)

Multi selected items to worksheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions