View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave H
 
Posts: n/a
Default Default Cell Value with Validation Drop-Down List

I have set up a set of cells with drop-down lists created through
data=validation. Is there a way to set a default value in one of these
cells if nothing is selected from the drop-down?