VBA: How to clear listbox items?

[dbmathis]

Hi all,

I have a simple question. How does one clear a listbox with VBA?

Thanks

 

[Norie]

What do you mean by clear?

Clear the contents?

Listbox1.Clear

Clear the selection(s)?

Listbox1.ListIndex = -1

 

[Andrew Poulsom]

If it's filled with AddItem:

ListBox1.Clear

If it's filled with RowSource:

ListBox1.RowSource = ""

 

[dbmathis]

Hmmm. It was actually filled with an array. I tried .clear before I posted and it didn't work? Now it does? Must have been a typo.

Thanks for the prompt response.

 

[dumitrudan608]

If you use the .clear method it leaves empty rows at the end of the list. If i fill it up with a smaller list than it will leave empty entries that i can select at the bottom of the list. Does it function like an array and i need to redim it?

 

[Mustang0710]

Important response on different method to clear based on how it was loaded. I was getting an "unspecified error" when using ListBox1.Clear because it was filled with RowSource. Changed to ListBox1.RowSource = "" and it works great. Thanks

 

[Ark68]

Doing what Mustang0710 did in post #6 is what I needed, however, is there a way to retain the header rows in the listbox after the other rows have been cleared?