Simple Listbox question - how to remove items

[TBA]

How can I remove all items from a listbox by looping through them?

-gk-

 

[Robin Hammond]

Either

lstName.Clear

or something like:

with lstName
while .listcount >0
.RemoveItem(0)
loop
end with

Robin Hammond
www.enhanceddatasystems.com

 

[Rob van Gelder]

ListBox1.Clear

Rob

 

[Chip Pearson]

Try something like

ListBox1.Clear


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com