When user use copy and paste to enter some values in the cells, it seem
that copy and paste and bypass the verification function in the cell
For example, I added a verification function in a cell and limits use
to input numeric data only. However, user can still paste som
characters in that cell with no problem. How do I handle this case

--
Message posted from http://www.ExcelForum.com

Unfortunately, pasting into a cell wipes out its data validation.

--

Vasant

"francislee " wrote in message
...
When user use copy and paste to enter some values in the cells, it seems
that copy and paste and bypass the verification function in the cell.
For example, I added a verification function in a cell and limits user
to input numeric data only. However, user can still paste some
characters in that cell with no problem. How do I handle this case?


---
Message posted from http://www.ExcelForum.com/