Remove all Listbox items

Todd Huttenstine · Jul 12, 2004

Whats the quickest way to remove every item in a listbox?

Todd

Dick Kusleika · Jul 12, 2004

Todd

It depends how it was populated

Me.ListBox1.Clear

if the AddItem method was used and

Me.ListBox1.RowSource = ""

if the RowSource property was used.

Todd Huttenstine · Jul 12, 2004

nevermind. Im going to use .clear

Todd Huttenstine · Jul 12, 2004

Thanks
Todd Huttenstine

-----Original Message-----
Todd

It depends how it was populated

Me.ListBox1.Clear

if the AddItem method was used and

Me.ListBox1.RowSource = ""

if the RowSource property was used.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

.