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

take the fmMultiSelectExtended option.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MikeT" <[email protected]> wrote in message
news:[email protected]...
> 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

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>