| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Multi Select
Hi All!
I have a multi-select liststyleoption (checkboxes) listbox on a worksheet. Is there any way to mimic Explorer "Shift Select" behavior? I'd like the user to check a list item, hold the shift key, select another item, and have all items in between automatically get checked. How would I make that happen using VBA? Thanks! Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox Multi Select
take the fmMultiSelectExtended option.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "MikeT" wrote in message ... Hi All! I have a multi-select liststyleoption (checkboxes) listbox on a worksheet. Is there any way to mimic Explorer "Shift Select" behavior? I'd like the user to check a list item, hold the shift key, select another item, and have all items in between automatically get checked. How would I make that happen using VBA? Thanks! Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox Multi Select
Awesome! Thanks a lot!
"Bob Phillips" wrote: take the fmMultiSelectExtended option. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "MikeT" wrote in message ... Hi All! I have a multi-select liststyleoption (checkboxes) listbox on a worksheet. Is there any way to mimic Explorer "Shift Select" behavior? I'd like the user to check a list item, hold the shift key, select another item, and have all items in between automatically get checked. How would I make that happen using VBA? Thanks! Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Multi in Listbox - Event Click not working | Excel Programming | |||
| using a multi-select listbox to pull data | 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 | |||
Linear Mode
