Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All!
I am a newbee in vba, so be indulgent. I create a listbox in a sheet: With Sheets("Step4") Set list_Box = .Shapes.AddFormControl(xlListBox, w, x, y, z) list_Box.ControlFormat.AddItem "1" list_Box.ControlFormat.AddItem "2" list_Box.ControlFormat.AddItem "3" list_Box.ControlFormat.AddItem "4" list_Box.ControlFormat.MultiSelect = xlSimple 'list_Box.ControlFormat.LinkedCell = .Cells(i, 9).Address It goes fine, the list box appears, it is mutli-select. But now, I want to retrieve the selected items, by their names or position. It seems I can not do list_Box.Selected(i) nor list_Box.ControlFormat.Selected(i) because it is not an ActiveX listbox. I can not do .value because it is multi-select, and .LinkedCell does not seem to work : I just get nothing or 0. So how can I extract the selected values from my listbox? Please help me. Olivier |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MultiSelect Listbox | Excel Programming | |||
How do I use a multiselect listbox | Excel Programming | |||
change combobox values one by one based on selection in multiselect listbox | Excel Programming | |||
Multiselect Listbox use | Excel Discussion (Misc queries) | |||
Multiselect Listbox | Excel Programming |