Thread: pull down list and single value allowed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default pull down list and single value allowed
Debra Dalgleish shows how to do it he

http://www.contextures.com/xlDataVal03.html

Hope this helps.

Pete

On Jul 2, 5:14*am, s v <s v @discussions.microsoft.com wrote:
I have a column I want to prioritize from 1 to 11. I want to have those
values in a pull down list. I also want to only be able to use each value
once, if the same value is used again I need it to use the new one and get
rid of the old one.

Any thoughts?

Reply With QuoteReply With Quote