How can I list the properties of a validation box?

[MPW]

Hi All,

I would like to list all the specs of a validation box.
Details like:
Validation Criteria
The range it uses or list info
Input Message
Error Alert info
etc.

I would also like to know how to apply these kind of attributes to a cell.

Thanks

 

[RoryA]

The Validation property of a range returns a Validation object, which has all the properties you want - you can view them all in the Object Browser.

 

[MPW]

So something like:

With Range("A1")
   .AlertStyle:=xlValidAlertWarning
   .ErrorMessage = "Don't do that!"
   .etc

I have played around with the object browser before but really wasn't too clear on what to do with it. Other than the 'Helps' is there a quick way to understand each item? For instance, IMEMode

Anyway thanks for pointing the way, I should be able to muddle through it now.

MPW

 

[RoryA]

If you select Validation in the left hand list in the OB you will see all its properties and methods in the right hand list. You don't actually want to view the properties of the dropdown, but of the Validation object

 

[MPW]

Thanks for the info.

Is there a good way to test whether a cell has validation like you would for a formula?
HasFormula = True

HasValidation = True

 

[RoryA]

Not that I know of - you have to check a property like Type within an error handler, if I remember rightly. (don't have Excel here)

 

[MPW]

I did find this:

http://www.pcreview.co.uk/forums/testing-cell-validation-t991949.html

I am going to test it now but it looks promising.