View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Working with ListBox with frmListStyleOption set

I have a ListBox, on a UserForm, with the ListStyle property set to
frmListStyleOption. What I am trying to figure out is a way to limit the
number of items that can be selected in the ListBox to, say 5. And once 5
items have been selected I want the rest of the items in the ListBox disabled.
Is there a way to do this? If so, please point me in the right direction.
Thanks
Ayo