View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default disable listitem

You can disable a listbox entirely like this:

ListBox1.Enabled = False

I do not believe it is possible to disable selecting some but not all items.

--
Jim Rech
Excel MVP
"Roland" wrote in message
...
| Which method do I have to use to disable items in a list- or combobox, so
the
| user can't select them, without removing them?
| Thanks