View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default 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-