Excel VBA multiple selection

LISTBOX 3 連結了SHEET2 的資料, 可以multiple selection
如何可以將所選的值立即顯示在另一個LISTBOX 或者 TEXTBOX內

Private Sub ListBox3_Change()
Dim lItem As Long
For lItem = 0 To ListBox3.ListCount - 1
If ListBox3.Selected(lItem) = True Then
ListBox4.Value = ListBox3.List(lItem)
ListBox3.Selected(lItem) = False
End If
Next

End Sub

Excel VBA multiple selection
2017-02-14 12:39 發佈



Private Sub ListBox1_Change()

With ListBox1
If .Selected(.ListIndex) = True Then
ListBox2.AddItem .List(.ListIndex)
TextBox1.Text = TextBox1.Text & .List(.ListIndex) & vbCrLf
End If
End With

End Sub
內文搜尋
X
評分
評分
複製連結
Mobile01提醒您
您目前瀏覽的是行動版網頁
是否切換到電腦版網頁呢?