I need to populate a ComboBox in a VBA form with values from a column in a worksheet but I want to remove any duplicate values. The column contains a list of last names and I only want unique values to appear in the ComboBox.
The first names ComboBox on te form is then populated according to the last name selected. This part I have working but I'm stumped as to removing the duplicates!
The first names ComboBox on te form is then populated according to the last name selected. This part I have working but I'm stumped as to removing the duplicates!