hi,
i am trying to avoid situation when user want to copy and paste something into range when i have DV lists.
So for example i have DV rule like:
but when i am pasting for example string "ddsdssd" it is working! DV list is not triggered.
Please Login or Register to view this content.
Can anybody had the similar issue?
Best,
Jacek
If you copy and paste a cell into a cell with DV, you overwrite the Target cell AND its DV.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you TMS,
it is possible to trigger it somehow?
Best,
Jacek
Well, the paste should trigger a Worksheet Change event so you could pick it up there, check the cell and reinstall the DV in the cell.
ok reinstall DV in the cell still will allow to keep wrong value there.
If you have for example 1 in cell and DV rule is >1 and you will paste this DV rule into this cell there will be still 1 and DV list will be not triggered.
Best,
Jacek
You'll need to validate the cell after reinstating the DV rule.
Rory
Thank you Rory,
i saw you on stackoverflow - nice picture
So i can not trigger copied DV lists and i have to write code by my own wth DV rule?
Best,
Jacek
DV doesn't get applied to data already in the cell. All you need to do is check the Validation.Value - if it's True then the data meets the rules.
ok thank you,
what is validation.value and how to use it ?
so you can go through all range, and somehow get validation.value to check if it is true?
Best,
Jacek
The Validation property of a range returns its data validation. If the Value property is True, then the data passes the validation rule.
ok great thank you very much! I will test it!
Jacek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks