Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel - count sleected items in a listbox
Is it possible to count the SELECTED items of a ListBox
--- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel - count sleected items in a listbox
Try:
Sub CountSelected() Dim LB As ListBox, i As Integer Dim X As Integer X = 0 Set LB = ActiveSheet.OLEObjects(1).Object For i = 1 To LB.ListCount If LB.Selected(i - 1) = True Then X = X + 1 Next MsgBox X End Sub Regards, Greg -----Original Message----- Is it possible to count the SELECTED items of a ListBox --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to drag items within listbox | Excel Discussion (Misc queries) | |||
Listbox--moving items up or down | Excel Programming | |||
listing items from listbox | Excel Programming | |||
Counting items in a listbox | Excel Programming | |||
Checking Listbox Items | Excel Programming |