View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Validation - Force entry from drop down list

Hi,
Look into Debra web

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



"JeffH" wrote:

I'm trying to force the data entry from the drop down list. I thought if I
set the Error Alert to "Stop" it would prevent any entry other than that from
the drop down list, but I can still enter data not on the drop down list.

How can I the cell to only accept data from the drop down list?