Try this
![]()
Dim sSel As Integer With Me.Listbox1 For sSel = IIf(.ColumnHeads, 1, 0) To .ListCount - 1 If .Selected(sSel) Then Me.Label1.Caption = .List(sSel) End If Next sSel End Wi
Try this
![]()
Dim sSel As Integer With Me.Listbox1 For sSel = IIf(.ColumnHeads, 1, 0) To .ListCount - 1 If .Selected(sSel) Then Me.Label1.Caption = .List(sSel) End If Next sSel End Wi
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks