Excel: Find/Replace for Data Validation text or Worksheet Objects

[nwarnock]

I'm using Excel 2002 and 2003.

Has anyone had occasion to set up a macro to do Find/Replace (or even
just Find) on the Data Validation Input Text/Title, Worksheet Objects,
or the like?

Or perhaps a macro to dump the Data Validation set up in a worksheet or
workbook?

Hate to reinvent the wheel.

I'm starting to think in terms of a "Power" Find/Replace.

Thanks!
Neva

 

[C01d]

The code segment below shows how you can extract a cell's data
validation fields. The Validation object has more properties than what
is shown here.

Set r = Range("A1")
Title = r.Validation.InputTitle)
Msg = r.Validation.InputMessage)

 

[Debra Dalgleish]

There's code here to document the data validation on the active worksheet:

http://www.contextures.com/xlDataVal09.html

 

[nwarnock]

Thank you! I really appreciate the assistance.

Neva