how to list all validation cells on a sheet

[HCS]

hello,

i understand how to alter a validation drop down box using vb. how is it
possible to list using vb all validations drop downs that appear on a sheet?

Cheers

 

[papou]

Hi
To count ALL validation cells:
MsgBox
Worksheets("Feuil2").Cells.SpecialCells(xlCellTypeAllValidation).Count
BUT if you have different Validation types it will include all of them.

HTH
Cordially
Pascal

 

[keepITcool]

have a look at vba help for SpecialCells method
it has 2 modes to either select "AllValidation"
or "SameValidation"

and automates what you could manually do via
Goto Special



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[papou]

Please watch for unwanted carriage return:
MsgBox _
Worksheets("Feuil2").Cells.SpecialCells(xlCellTypeAllValidation).Count

Cordially
Pascal

 

[HCS]

Thanks to both of you that looks like what i need!

Cheers