View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pbHou pbHou is offline
external usenet poster
 
Posts: 1
Default 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?