View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GMet GMet is offline
external usenet poster
 
Posts: 23
Default ListBox filter

Is it possible to restrict access/selection of a listbox item based on some
criteria? For example:

Listbox1
Oranges
Lemons
Apples
Grapes
Pears

I can't filter the list to show only the non-citrus. Therefore all of the
fruits show including the Oranges and Lemons. But , is it possible for me
to restrict the selection so that the user can only select Apples, Grapes,
or Pears?

I know I could code it in the command button after the user selects etc.
However, I want to cause the restriction within the listbox. Is that
possible?

GMet