software

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 quot;Powerquot; 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(quot;A1quot;)
Title = r.Validation.InputTitle)
Msg = r.Validation.InputMessage)--
C01d
------------------------------------------------------------------------
C01d's Profile: www.excelforum.com/member.php...oamp;userid=34422
View this thread: www.excelforum.com/showthread...hreadid=544332There's code here to document the data validation on the active worksheet:

www.contextures.com/xlDataVal09.html

wrote:
gt; I'm using Excel 2002 and 2003.
gt;
gt; Has anyone had occasion to set up a macro to do Find/Replace (or even
gt; just Find) on the Data Validation Input Text/Title, Worksheet Objects,
gt; or the like?
gt;
gt; Or perhaps a macro to dump the Data Validation set up in a worksheet or
gt; workbook?
gt;
gt; Hate to reinvent the wheel.
gt;
gt; I'm starting to think in terms of a quot;Powerquot; Find/Replace.
gt;
gt; Thanks!
gt; Neva
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlThank you! I really appreciate the assistance.

Neva