Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to parse a multi-colum multi-select listbox
Hello Everyone,
I need some help. I need to develop code to parse a multi-column multi-select listbox and put the values in a worksheet. This is the code I have but it's only giving me the last item selected and I need to capture all items selected in the multi-select, multi- column Listbox. With Me.ListBox2 For i = 0 To .ListCount - 1 If .Selected(i) Then UserForm1.Spreadsheet1.Range("a65536").End(xlUp) = sPrompt & .Column(0, i) UserForm1.Spreadsheet1.Range("B65536").End(xlUp) = sPrompt & .Column(1, i) End If Next i Again, any help would be great. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox Multi Select | Excel Programming | |||
Multi Colum Listbox in UserForm | Excel Programming | |||
Multi-select listbox help! | Excel Programming | |||
multi select listbox | Excel Programming | |||
Extract values from a multi-select multi-column list-box | Excel Programming |