View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Validating Cells

Yes it is. Give the list a name (InsertNameDefine...), and then use the
name in the data validation.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TheRook" wrote in message
...
When validating cells is it possible to pick the list critria from a
different sheet?

Regards

The Rook