Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting multiple items and columns from ListBox
Hi:
The code below works for returning selected items in a multiple select ListBox. What Im trying to do (without much success) is modify the code to select multiple items and multiple columns. Any help or examples will be greatly appreciated. Private Sub CommandButton1_Click() For x = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(x) = True Then ActiveCell.Value = UserForm2.ListBox1.List(x) End If Next x End Sub Thanks TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Multiple Items and return value for Dropdown or listbox | Excel Discussion (Misc queries) | |||
Moving Mutli-Column Multiple-Selected Listbox items up or down | Excel Discussion (Misc queries) | |||
Adding items to columns in a listbox | Excel Discussion (Misc queries) | |||
Transfer multiple columns items form listbox to range | Excel Programming | |||
Selecting multiple rows from listbox for reporting | Excel Programming |