| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
make use of cell defined data validation in vba
Cate,
Try Range("A1").Validation.Value. From the help file: "Returns a Boolean value that indicates if all the validation criteria are met (that is, if the range contains valid data)." Thus, you could use the above property to check whether your changes are valid. If you capture the formula/value in a given range prior to making changes, then you could revert back to this original formula/value in the event that your code generates invalid data. Ben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make cell equal a word if a data validation cell has a word in it | Excel Discussion (Misc queries) | |||
| Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
| How to make an external link to a filename defined by a cell value | Links and Linking in Excel | |||
| Data Validation with Defined Name | Excel Worksheet Functions | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
Hybrid Mode
