Hi All,
i have following code. When user form is shown list box has focus on "item1" and not on "Select All"
anybody any idea on this![]()
Private Sub UserForm_Initialize() Dim vList vList = Array("item1", "item2", "item3") With Me.ListBox1 .List = vList ' add "Select all" as first item .AddItem "Select All", 0 End With ListBox1.Selected(0) = True End Sub
thanks
megha
Bookmarks