View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Select Whole List or Items in List Box

Dim i As Long

With Me.ListBox1

.MultiSelect = fmMultiSelectExtended
For i = 1 To .ListCount

.Selected(i - 1) = True
Next i
End With


--
__________________________________
HTH

Bob

"K" wrote in message
...
Hi all, I need macro on a button which can select all the items or
list in ListBox1. Please can any friend can help.