Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate cell when contents are pasted into it
I have a set of cells which are validated against a list so that when someone
types content into the cell, what is typed must be consistent with the validation list. This does not require VB code and works fine when values are typed into the cells, but not when they are pasted. I use the worksheet's Worksheet_SelectionChange(ByVal Target As Range) subprocedure and an If Then statement to detect when a particular set of cells changed, and set validation ranges according to the contents of reference cells. But I don't have any idea how to validate values pasted into a cell or cell range against a list. I would appreciate any help I can get. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validate Cell contents in formlua | Excel Worksheet Functions | |||
Worksheet_Selection Change code will not allow cell contents to be copied and pasted onto the sheet it's running on | Excel Programming | |||
Newbie question: clear contents in first column of copy-pasted row(s) | Excel Programming | |||
How to validate in code the contents of a cell? | Excel Programming | |||
Validate value in cell | Excel Programming |