Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting all items in a Listbox???
Hi,
Livvo is asking if I can get a multi-select listbox to select all items in the box at the click on a button on the form. Anybody know how to do this? Ta |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting all items in a Listbox???
Private Sub CommandButton1_Click()
Dim i as integer For i = 0 To ListBox1.ListCount - 1 ListBox1.Selected(i) = True Next i End Sub -- Hope that helps. Vergel Adriano "Neily" wrote: Hi, Livvo is asking if I can get a multi-select listbox to select all items in the box at the click on a button on the form. Anybody know how to do this? Ta |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting all items in a Listbox???
Private Sub CommandButton1_Click()
Dim i As Integer For i = 0 To ListBox1.ListCount - 1 ListBox1.Selected(i) = True Next i End Sub -- Hope that helps. Vergel Adriano "Neily" wrote: Hi, Livvo is asking if I can get a multi-select listbox to select all items in the box at the click on a button on the form. Anybody know how to do this? Ta |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting all items in a Listbox???
Brilliant, Ta.
"Vergel Adriano" wrote: Private Sub CommandButton1_Click() Dim i As Integer For i = 0 To ListBox1.ListCount - 1 ListBox1.Selected(i) = True Next i End Sub -- Hope that helps. Vergel Adriano "Neily" wrote: Hi, Livvo is asking if I can get a multi-select listbox to select all items in the box at the click on a button on the form. Anybody know how to do this? Ta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting multiple items on Listbox | Excel Programming | |||
1. Selecting multiple items from drop listbox | Excel Programming | |||
Selecting Multiple items in ListBox | Excel Programming | |||
Selecting multiple items and columns from ListBox | Excel Programming | |||
Adding Items to a ListBox-Unique Items Only | Excel Programming |