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

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

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)

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

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


[email protected] wrote:
> 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
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thank you! I really appreciate the assistance.

Neva