Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select multiple items in a listbox
Hi, I'm putting together a userform which has two list boxes. One will b populated with a number of items the other empty. I have made it so that the user can select an item and transfer it fro one list box to the other. I'd like to make it so that the user can hold the cntrl key down an select several items in one list box all at once. Any suggestions? This one really has me stumped. Thanks E -- uece ----------------------------------------------------------------------- uecem's Profile: http://www.excelforum.com/member.php...fo&userid=1513 View this thread: http://www.excelforum.com/showthread.php?threadid=32043 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select multiple items in a listbox
Hi uecem
In the properties of the listbox set Multiselect to 1 You don't have to use the Ctrl key to do this If you click on a item it select it and if you click again it unselect it -- Regards Ron de Bruin http://www.rondebruin.nl "uecem" wrote in message ... Hi, I'm putting together a userform which has two list boxes. One will be populated with a number of items the other empty. I have made it so that the user can select an item and transfer it from one list box to the other. I'd like to make it so that the user can hold the cntrl key down and select several items in one list box all at once. Any suggestions? This one really has me stumped. Thanks Ed -- uecem ------------------------------------------------------------------------ uecem's Profile: http://www.excelforum.com/member.php...o&userid=15131 View this thread: http://www.excelforum.com/showthread...hreadid=320437 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select multiple items in a listbox
This might help, too:
http://groups.google.com/groups?selm...BDD4%40msn.com uecem wrote: Hi, I'm putting together a userform which has two list boxes. One will be populated with a number of items the other empty. I have made it so that the user can select an item and transfer it from one list box to the other. I'd like to make it so that the user can hold the cntrl key down and select several items in one list box all at once. Any suggestions? This one really has me stumped. Thanks Ed -- uecem ------------------------------------------------------------------------ uecem's Profile: http://www.excelforum.com/member.php...o&userid=15131 View this thread: http://www.excelforum.com/showthread...hreadid=320437 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select Multiple Items and return value for Dropdown or listbox | Excel Discussion (Misc queries) | |||
Problem using INDEX to select items in listbox | Excel Discussion (Misc queries) | |||
select mulitiple columns and items from a listbox | Excel Programming | |||
Selecting Multiple items in ListBox | Excel Programming | |||
SELECT, ERASE, EDIT items in listbox | Excel Programming |