Hi GMet

Look here for a possible solution
http://www.contextures.com/xlDataVal02.html

--
Regards Ron de Bruin
http://www.rondebruin.nl


"GMet" wrote in message ...
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