| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Additems from one listbox with multiple columns to another
Thank you Dave.
"Dave Peterson" wrote: What line causes the error? I didn't notice this before, but I think you'll want to change this portion: If .lst_bs_school.Selected(x) = True Then .lst_bs_bm.AddItem .lst_bs_school.List(x, 0) .lst_bs_bm.List(.lst_bs_bm.listcount-1, 2) = .lst_bs_school.List(x, 1) .lst_bs_bm.List(.lst_bs_bm.listcount-1, 3) = .lst_bs_school.List(x, 2) .lst_bs_bm.List(.lst_bs_bm.listcount-1, 4) = .lst_bs_school.List(x, 3) .lst_bs_bm.List(.lst_bs_bm.listcount-1, 5) = .lst_bs_school.List(x, 4) .lst_bs_bm.List(.lst_bs_bm.listcount-1, 6) = .lst_bs_school.List(x, 5) '.lst_bs_school.Selected(x) = False End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting corresponding columns on a multiple select listbox | Excel Programming | |||
| adding multiple columns to a listbox | Excel Programming | |||
| multiple columns / rows to be referenced through a listbox | Excel Discussion (Misc queries) | |||
| Selecting multiple items and columns from ListBox | Excel Programming | |||
| Multi-column ListBox. Multiple bound columns??? | Excel Programming | |||
Threaded Mode
