No duplicates in listbox vba excel

Question

i have a listbox which adds items with a button, every time i click it again adds up those same items which i dont want . can there be any solution for this in VBA?

Answer 1

Remove the old items before adding new ones, using

ListBox1.Clear