Remove all Listbox items

  • Thread starter Thread starter Todd Huttenstine
  • Start date Start date
T

Todd Huttenstine

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

Todd
 
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.
 
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




.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Using DAO.Database VBA code to populate a listbox from another listbox selection 1
Blank item in listbox, how to remove 3
Access Cannot select items in listbox 1
listbox remove 1
Listbox 1
refresh listbox 2
Refresh Listbox 2
Clearing a listbox 3

Back
Top