Code To Empty A ListBox?

[charllie]

Hi Folks,

I am using this code to empty a listbox put it doesn't appear to work.I have also tried ClearContents.

I was wondering if anyone has another code i could try.

Worksheets("Team Leader Screen").ScreenListBox.Clear 'Empty the listbox

Thanks

 

[Norie]

How is it not working?

What type of listbox is it?

When you say you want to 'clear' it what do you mean? Do you want to remove all the items from it?

 

[charllie]

Hi Norie,

Yes i would just like to empty it completely so i can then start to put things in at the start of a new day.

I am not getting any error messages, it just doesn't work. Weird but thats why i thought i would try a different code. All the spelkling etc is ok.

Thanks

 

[Norie]

How is the listbox populated?

 

[charllie]

Hi Norie,

Sorry for delay, i had a few major proble,s to sort out. I need to deal with them first. Can i come back to you on this?

Thanks

 

[Fat Cat]

Hi Mike,

If its a ListBox on a UserForm, you can use .Clear

eg; ListBox1.Clear

If its a ListBox on a Sheet, you can set the .ListFillRange to blank

eg; ListBox1.ListFillRange = ""