View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default lock listbox items

AFAIK it's not possible.
Also, that would confuse the user; why give them the choice if they cannot
select it ?
Edit the list before you show it.

NickHK

"enyaw" wrote in message
...
Is there a way of locking individual items in a listbox on a userform so

as
they cannot be selected by the user?