Home |
Search |
Today's Posts |
#1
|
|||
|
|||
List Box Selections
Please help,
I have a List box from which I want to be able to select multiple options and from this hide the rows other than the selected rows. What vba code can I use to do this. Thanks, Jez |
#2
|
|||
|
|||
List Box Selections
With Me.ListBox1
For i = 0 To .ListCount - 1 If .Selected(i) Then Range(myData).Offset(i,0).Entirerow.Hidden = True End If Next i End With This assumes that the listbox is sourced from a range named myData. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jez" wrote in message ... Please help, I have a List box from which I want to be able to select multiple options and from this hide the rows other than the selected rows. What vba code can I use to do this. Thanks, Jez |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple selections from a drop down list in Excel... | Excel Worksheet Functions | |||
Maximum selections in a mutil list box | Excel Discussion (Misc queries) | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |