Do NOT allow validations to be overwritten with non-validation values

[thewiseguy]

Hi all,

I have a VBA to not allow cut and paste within a specific range, however what I am really searching for is to be able to copy paste into a cell which has a validation list but of the value being pasted does not match a value within the validation list then it will not allow it.

Is this possible?

Thanks in advance!

 

[Joe4]

The issue is that Copy/Paste also copies the formatting of the source cell, so it would overwrite any existing Conditional Formatting rules.
You can instead use Worksheet_Change event procedure VBA code to restrict what goes in that cell. So you would have to set the rules in the VBA code.
We can probably help you with that if you provide the details.

Of course the caveat there is that VBA/Macros need to be enabled for any VBA code to work.

 

[thewiseguy]

The issue is that Copy/Paste also copies the formatting of the source cell, so it would overwrite any existing Conditional Formatting rules.
You can instead use Worksheet_Change event procedure VBA code to restrict what goes in that cell. So you would have to set the rules in the VBA code.
We can probably help you with that if you provide the details.

Of course the caveat there is that VBA/Macros need to be enabled for any VBA code to work.

ok great. thanks for the info!