I am trying to do a user form by Excel VBA, how can I remove the duplicate selection in the Listbox? The Rowsource is one column G of the raw data as the second image shows: enter image description here
I can't just change the RowSource to the cell that only contain 2010, 2015,2020 because there maybe new data enter later and they may be other year Anyone know how to code it? Thank you very much