وعليكم السلام
احذف 'Me.ListBox1.AddItem
عند تحقق الشرط ليصبح الكود بهذا الشكل
Private Sub Image1_Click()
X = 0
For i = 0 To Me.ListBox1.ListCount - 1
If Me.ListBox1.List(i, 0) = Label1.Caption Then
X = 1
Exit For
End If
Next i
TextBox1 = WorksheetFunction.VLookup(Label1, Range("d4:h99"), 5, 0)
If X = 1 Then
'Me.ListBox1.AddItem
Me.ListBox1.List(i, 1) = Me.ListBox1.List(i, 1) + 1
Me.ListBox1.List(i, 2) = Me.ListBox1.List(i, 1) * TextBox1
Else
Me.ListBox1.AddItem
Me.ListBox1.List(Me.ListBox1.ListCount - 1, 0) = Label1.Caption
Me.ListBox1.List(Me.ListBox1.ListCount - 1, 1) = 1
Me.ListBox1.List(i, 2) = TextBox1
End If
End Sub
Private Sub Image2_Click()
X = 0
For i = 0 To Me.ListBox1.ListCount - 1
If Me.ListBox1.List(i, 0) = Label2.Caption Then
X = 1
Exit For
End If
Next i
TextBox1 = WorksheetFunction.VLookup(Label2, Range("d4:h99"), 5, 0)
If X = 1 Then
'Me.ListBox1.AddItem
Me.ListBox1.List(i, 1) = Me.ListBox1.List(i, 1) + 1
Me.ListBox1.List(i, 2) = Me.ListBox1.List(i, 1) * TextBox1
Else
Me.ListBox1.AddItem
Me.ListBox1.List(Me.ListBox1.ListCount - 1, 0) = Label2.Caption
Me.ListBox1.List(Me.ListBox1.ListCount - 1, 1) = 1
Me.ListBox1.List(i, 2) = TextBox1
End If
End Sub