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?

show us the code you already built and what you've tried so far — JMax
– JMax, Commented Nov 5, 2011 at 9:05

chris neilsen · Accepted Answer · 2011-11-05 09:13:18Z

1

Remove the old items before adding new ones, using

ListBox1.Clear

answered Nov 5, 2011 at 9:13

chris neilsen

53.3k10 gold badges91 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1000730 Over a year ago

The above answer does solve the problem but a message box should be prompting up after clicking once

Collectives™ on Stack Overflow

No duplicates in listbox vba excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related