View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Working with ListBox with frmListStyleOption set

Maybe this:
http://www.cpearson.com/excel/ListBoxUtils.htm

Good luck,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Ayo" wrote:

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