Using Excel 2000 & VBA, I have upon a userform a combobox populated with over 200 items from which a user may select or add their own.
When user makes selection they click a command_button to copy the selection to a listbox.
Prior to the copy I want to check to see that their selection is not already within the listbox as duplicates must not be present.
I have tried various methods but all end in failure...I am new to VBA so any help at all would be much appreciated.
My questions therefore are as follows:
1. How can I make the comparison?
2. Can it be done without too much impact upon
performance, as 100+ items may regularly be a
requirement.
Regards
Rodopi
When user makes selection they click a command_button to copy the selection to a listbox.
Prior to the copy I want to check to see that their selection is not already within the listbox as duplicates must not be present.
I have tried various methods but all end in failure...I am new to VBA so any help at all would be much appreciated.
My questions therefore are as follows:
1. How can I make the comparison?
2. Can it be done without too much impact upon
performance, as 100+ items may regularly be a
requirement.
Regards
Rodopi