| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove all Listbox items
Whats the quickest way to remove every item in a listbox?
Todd |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove all Listbox items
nevermind. Im going to use .clear
-----Original Message----- Whats the quickest way to remove every item in a listbox? Todd . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove all Listbox items
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 "Todd Huttenstine" wrote in message ... Whats the quickest way to remove every item in a listbox? Todd |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove all Listbox items
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 "Todd Huttenstine" wrote in message ... Whats the quickest way to remove every item in a listbox? Todd . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Items to a ListBox-Unique Items Only | Excel Programming | |||
| Items in a Listbox | Excel Programming | |||
| Fill a ListBox with items using VBA | Excel Programming | |||
| Simple Listbox question - how to remove items | Excel Programming | |||
| Checking Listbox Items | Excel Programming | |||
Hybrid Mode
