View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Working with ListBox with frmListStyleOption set

You didn't like the suggestions from Wednesday?

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


--

Dave Peterson