Simple Listbox question - how to remove items
 

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

-gk-

Simple Listbox question - how to remove items
 

Either

lstName.Clear

or something like:

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

Robin Hammond
www.enhanceddatasystems.com

"TBA" wrote in message
...
How can I remove all items from a listbox by looping through them?

-gk-

Simple Listbox question - how to remove items
 

ListBox1.Clear

Rob

"TBA" wrote in message
...
How can I remove all items from a listbox by looping through them?

-gk-

Simple Listbox question - how to remove items
 

Try something like

ListBox1.Clear


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


"TBA" wrote in message
...
How can I remove all items from a listbox by looping through
them?

-gk-