首先,如果是一行行的,不如用listbox,然后每次插入记录时,先循环判断是否存在
dim I as long
for i=0 to list1.listcount-1
if list1.list(i)=插入的值 then
msgbox "记录已经存在'
exit for
else
list1.additem 插入的值
end if
next i
Private Sub Command1_Click()
Dim s() As String, t As New Collection, i As Long
s = Split(Text1.Text, vbCrLf)
On Error Resume Next
For i = 0 To UBound(s)
t.Add s(i), s(i)
Next
ReDim s(1 To t.Count)
For i = 1 To t.Count
s(i) = t(i)
Next
Text1.Text = Join(s, vbCrLf)
Erase s
End Sub