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.
.