Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiSelect ListBox in Excel
Is it possible to have a multiSelect ListBox or preferably
a Combobox created in Excel Toolbar. I can get a single select, but my app demands a multi. ANyone been here |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiSelect ListBox in Excel
Hi Pete
ListBoxes have a multiselect property. The default setting is zero. myListBox.multiselect = 0 It is all there in VB Help. Here is an extract Constant Value Description fmMultiSelectSingle 0 Only one item can be selected (default). fmMultiSelectMulti 1 Pressing the SPACEBAR or clicking selects or deselects an item in the list. fmMultiSelectExtended 2 Pressing SHIFT and clicking the mouse, or pressing SHIFT and one of the arrow keys, extends the selection from the previously selected item to the current item. Pressing CTRL and clicking the mouse selects or deselects an item. Remarks When the MultiSelect property is set to Extended or Simple, you must use the list box's Selected property to determine the selected items. Also, the Value property of the control is always Null. The ListIndex property returns the index of the row with the keyboard focus Regards Paul "PeteSmith" wrote in message ... Is it possible to have a multiSelect ListBox or preferably a Combobox created in Excel Toolbar. I can get a single select, but my app demands a multi. ANyone been here |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I have a multiselect option for a list box in excel 2003 | Excel Discussion (Misc queries) | |||
Multiselect Listbox use | Excel Discussion (Misc queries) | |||
Excel VBA-Looping though MultiSelect on ListBox | Excel Programming | |||
multiselect listbox | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |