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 listboxs and combo boxes

You say the listbox has a bunch of names - then you talk about things like
zipcode, state, as so forth. Is this a multicolumn listbox with all that
information for each name?

There is no built in method to sort a listbox's list.

Other than that, you would have to grab the list as an array, sort it
according to your selection in the combobox, then put it back in the
listbox.

What kind of help are you looking for?

--
Regards,
Tom Ogilvy



"Rich Cooper" wrote in message
...
I am working with both a combo box and a list box. The list box has a

bunch
of names. The combo box has some options and i want those options to sort
and filter the listbox. How do i do that? Some of the options are by
state, zipcode, city, last nmae, firstname? Any help wouldbe greatly
appreciated.