Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select Multiple Items and return value for Dropdown or listbox | Excel Discussion (Misc queries) | |||
Adding items to columns in a listbox | Excel Discussion (Misc queries) | |||
Problem using INDEX to select items in listbox | Excel Discussion (Misc queries) | |||
Selecting multiple items and columns from ListBox | Excel Programming | |||
SELECT, ERASE, EDIT items in listbox | Excel Programming |