preselect ALL items in Listbox

[carsto]

I have a Listbox with a varying number of items in the list.
90% of the time the user will select all the items in the list.
Is there a way to have all the items preselected?
Then the remaining 10% can unselect.

[Leith Ross]

Hello ,

Here is an example. You will need to change the ListBox name if it is different than yours.

Please Login or Register  to view this content.

[dominicb]

Good afternoon carst

Is there a way to have all the items preselected?
Then the remaining 10% can unselect.

Are we talking about a listbox in a userform?
If so use the code below (I'm assuming that your listbox is called ListBox1) :

Please Login or Register  to view this content.

Just make sure that your listbox is set up to accept multiple selections.

HTH

DominicB

[carsto]

Thank you both