Remove Selected Entries from Excel List
 

I am using Data Validation that allows a user to pick from a list when
clicking on a cell. My list that Data Validation refers is A5:A205. When a
user selects an entry from the list, how do you remove that entry, so it is
not selected again?

Remove Selected Entries from Excel List
 

You have to remove the entry from the range where the list gets its data.

You can use the Change event to see if the change was to the cell with the
Data validation. Then write code to remove that item from the list (and
perhaps reassign the extent of the list).

The basic code for making these range alterations, assignments could be
gained using the macro recorder while doing it manually.

If you not familiar with events, see Chip Pearson's page on events
http://www.cpearson.com/events.htm

--
Regards,
Tom Ogilvy


"pbHou" wrote in message
...
I am using Data Validation that allows a user to pick from a list when
clicking on a cell. My list that Data Validation refers is A5:A205. When
a
user selects an entry from the list, how do you remove that entry, so it
is
not selected again?