Validation List Fails

[stefen054]

hi

I have a worksheet wherein i have added validation list for entire column B . if the user paste non list item over any cell in that column the validation fails to message to user about the wrong value entered in the list.

Is there anyway other than disabling paste, i could do this.

Thanks in advance.
stefen

 

[xlbo]

not really - pasting data in is a major issue when you are trying to control input - the problem lies in the fact that when pasting, it is not just the values that get pasted but the formatting and everything else connected with the cell that is being pasted FROM...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[stefen054]

Thanks Geoff.

 

[xlbo]

something that might help:

Private Sub Worksheet_Activate()
Application.CutCopyMode = False
End Sub

This means that if they are pasting from another sheet - each time they activate your validated sheet, the clipboard will be cleared

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[stefen054]

Thanks Geoff.