View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Multiple Selection from COMBOX or ListBox

Set the multiselect property to the appropriate value

With Combobox1
for i = 0 to .Listcount - 1
if .selected(i) then
msgbox .list(i) & " is selected
end if
Next
End With
--
Regards,
Tom Ogilvy


"Wellie" wrote in message
...
I'd like to implement either a combox or listbox to allow user to select

multiple items from the list. Can someon please suggest me some hints as
how can I setup the combox/listbox as well as how to identify what are
selected ?

Thanks in advance