第1个回答 2013-08-26
'简单举例
'在窗口添加 Text1、 Text2 、List1、Command1 控键
'EXCEL粘帖过的文本放在Text1
'Command1按钮将Text1引入到List1,每行为一条记录
'点击List1选择内容,Text2 得出结果
Dim j1 As Long, j2 As Long, j3(1 To 3) As String
Private Sub Form_Load()
Text1.Text = ""
Text2.Text = ""
Command1.Caption = "引入Text1文本"
j1 = 1
j2 = 0
End Sub
Private Sub Command1_Click()
T = Split(Text1.Text, vbCrLf)
List1.Clear
For i = 0 To UBound(T)
If T(i) <> j3(1) And T(i) <> j3(2) And T(i) <> j3(3) Then List1.AddItem T(i)
Next
End Sub
Private Sub List1_Click()
If j2 = 0 Then Text2.Text = Text2.Text & "第" & j1 & "次选择" & vbCrLf
Text2.Text = Text2.Text & List1.Text & vbCrLf
j2 = j2 + 1
j3(j2) = List1.Text
List1.RemoveItem (List1.ListIndex)
If j2 = 3 Then j1 = j1 + 1: j2 = 0: Command1_Click
End Sub
'打字很辛苦滴!请采纳!谢谢!本回答被网友采纳