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

  • Thread starter Thread starter nwarnock
  • Start date Start date
N

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
 
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)
 
Back
Top