Working with ListBox with frmListStyleOption set

A

Ayo

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
 
D

Dave Peterson

You didn't like the suggestions from Wednesday?
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A form combobox with list style as options. 1
Listbox search question 4
how to work with all items in a listbox 1
User Input to Generate ListBox Range 0
Set Cell value form ListBox. 4
Listbox selected 2
How to set focus on an ActiveX ListBox 7
Multi-select listbox - mousedown event 2

Top