Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have defined multiple cells with (varying) length validation rules....as
noted in other threads, data validation is not enforced when user populates with copy/paste....since copy/paste does trgger "worksheet change" event, how can I invoke the cells "defined" validation routine from within "Worksheet_Change"? My preference is to leverage the cells defined validation settings to avoid writing individualized subroutines/logic per cell, per worksheet..... I know using "Worksheet.CircleInvalid" does perform validation of the cells in defined range, because the invalid ones are "circled".....problem is, circling cell doesn't "enforce" validation restrictions. Any/all help is greatly appreciated.... MPR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation - copy paste ! | Excel Worksheet Functions | |||
Data Validation (copy paste error) | Excel Worksheet Functions | |||
Data Validation (copy paste error) | Excel Worksheet Functions | |||
Copy Paste overides data validation | Excel Programming | |||
Copy/Paste over rides data validation | Setting up and Configuration of Excel |