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

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

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)


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=544332

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

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

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


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

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

Thank you! I really appreciate the assistance.

Neva