View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NightLord NightLord is offline
external usenet poster
 
Posts: 7
Default How to force cell input from a List?

On Sheet1, Column B, a name must be entered. I don't want folks typing the
name, though, because spelling is important.
Thus, on Sheet2 I have created a List with the names they can choose from.
How do I make Columb B in Sheet1 use a drop-down for all of it's Cells, and
ONLY accept input from that drop-down list?

Thanks much!