View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Passing multiselections from listbox to sub

I have a listbox where the selected item is passed to a sub:

NewSub(listbox1.Value)

I want to turn on the multiselect and pass all selected values to the same
sub. Is the only way of doing this by sending the multiselect items to an
array and pass the array to the sub?

If so, how do you pass the items from the listbox to the array.

Thanks

EM