I have a user form that has a combo box that is populated by a range from a worksheet. All the data collected in the user form are then written to a worksheet called Data. What I would like to do is to exclude all the items that has been selected already. Say for example my Rowsource range contains the ff:
Oranges
apples
grapes
bananas
and so on .....
If the user has already selected and entered Oranges(in cell A1) & apples(in cell A2) to the Data worksheet it will no longer be in the dropdown list of the combo box.
Any help will be greatly appreciated.
Thanks
Nokoy
Oranges
apples
grapes
bananas
and so on .....
If the user has already selected and entered Oranges(in cell A1) & apples(in cell A2) to the Data worksheet it will no longer be in the dropdown list of the combo box.
Any help will be greatly appreciated.
Thanks
Nokoy