View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
MikeT MikeT is offline
external usenet poster
 
Posts: 32
Default 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