|
- Private Sub ListBox1_MouseUp(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) '用这个触发
- Dim w$, n%
- w = ActiveCell '取出单元格数据
- w = Replace(w, ",", " ") '将逗号换成空格,用工作表函数trim去除多余空格后再加逗号
- With ListBox1
- For n = 0 To .ListCount - 1
- If .Selected(n) = True And InStr(w, .List(n)) = 0 Then '当有选定和没有找到,则加入
- w = w & " " & .List(n)
- ElseIf .Selected(n) = False And InStr(w, .List(n)) > 0 Then '当没有选定及单元格内有数据,则删除
- w = Replace(w, .List(n), "")
- End If
- Next
- w = Application.WorksheetFunction.Trim(w) '去除多余的空格
- ActiveCell.Value = Replace(w, " ", ",")
- End With
- End Sub
复制代码
|
评分
-
查看全部评分
|