View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete McCOsh Pete McCOsh is offline
external usenet poster
 
Posts: 64
Default Validation (Drop down list vs simple text length validation)

Jac,
you can query:

Activecell.validation.incelldropdown

This will return true if there is a drop down list cause
an error if not.

Cheers, Pete

-----Original Message-----
Hi everyone,
I want to know how to distinguish between a cell that

displays a drop down list in a cell and another that does
not.

Thank you.
.