Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell validation even for values pasted into cells
The cell validation feature works fine when a user types a value into a cell,
but does not prevent pasting in a value that does not meet the validation criteria. Is there a way to validate values that are pasted into a cell? |
#2
|
|||
|
|||
I think you can prevent pasting by locking the cell and protecting the
sheet, but I don't believe you can validate a pasted value unless you use VBA code to react to the action. -- Regards, Tom Ogilvy "JR_06062005" wrote in message ... The cell validation feature works fine when a user types a value into a cell, but does not prevent pasting in a value that does not meet the validation criteria. Is there a way to validate values that are pasted into a cell? |
#3
|
|||
|
|||
Can I get some help with the VB code on this board or do I need to go to the
Excel programming board? I know code that will test for a given value to a cell, but I don't know how to test for pasted values even in VB. I'm guessing that the code would go in either the worksheet sub-procedure Worksheet_SelectionChange(ByVal Target As Range) or Private Sub Worksheet_Change(ByVal Target As Range) and I would also guess that Cells(col,row).value property might be used. But I have no idea how to determine if a value is pasted or typed into a cell, or how to test pasted values against a list of values as opposed a single value, a procedure which is easy to do with typed values using the data validate routine. End Sub "Tom Ogilvy" wrote: I think you can prevent pasting by locking the cell and protecting the sheet, but I don't believe you can validate a pasted value unless you use VBA code to react to the action. -- Regards, Tom Ogilvy "JR_06062005" wrote in message ... The cell validation feature works fine when a user types a value into a cell, but does not prevent pasting in a value that does not meet the validation criteria. Is there a way to validate values that are pasted into a cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I view cell text without it visually hiding other cells? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Format Validation Cells | Excel Discussion (Misc queries) | |||
Need to find the right-most cell value in a string of cells | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions |