Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting items from list box multi-select onto worksheet
I'm trying to get items picked from a multi-select list box onto my Excel 2000 active worksheet. Obviously I've had no luck. All examples I've looked at on the Knowledge base seem useless. So far, no matter what I try, the items picked only show up in a Message Box. I've created a Userform with a listbox and command button. The command button is supposed to determine which list items have been picked and put them in the worksheet. A separate macro in the worksheet calls up the Userform. The following code is what I started with. I tried to activate the worksheet, dump the results into an array, etc., but nothing seems to work. Any help on this would be GREATLY appreciated
Sub CommandButton1_Click( ' Loop through the items in the ListBox control For x = 0 To ListBox1.ListCount - ' If the item is selected.. If ListBox1.Selected(x) = True The Msg = ListBox1.List(x) *** Note: Even if this is commented out, the results still come up on a "message box" like window. Also, all other methods tried so far produce the same results. **** End I Next ' Close the UserForm 'Unload M End Su Sub Button3_Click( Userform1.Sho End Su |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Box - Multi Select Issue | Excel Worksheet Functions | |||
Is there a way to sort a list of multi-line items? | Excel Worksheet Functions | |||
multi-select drop down list | Excel Programming | |||
Extract values from a multi-select multi-column list-box | Excel Programming | |||
Multi Select List Box | Excel Programming |